468,777 Members | 2,039 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,777 developers. It's quick & easy.

Data Entry Form: Save Button

Hi guys,

Im trying to implement the following, but having trouble doing so.

I have form that shows saved records of project details.

with this form, i want to be able to add new project details, and also scroll through the saved ones, and edit them.

The problem is, i dont want to save a new record, or edit a record, until some sort of trigger/button has been clicked.

Currently, when i enter in data, or edit data, if i close the form with [x], it saves the data into the table. How can i go about disabling this, so that the data is only saved into the table when i click [Save]. ?

thanks guys
Oct 5 '06 #1
2 5567
Tanis
143 100+
Therre is no easy answer to this one. Have a look here
http://www.access-programmers.co.uk/forums/showthread.php?t=38364
May help
Oct 5 '06 #2
PEB
1,418 Expert 1GB
So you need to go to before update event in your form and there write a little code...

Maybe you can do showing a msgbox that asks the user if he want to save the record...

If result= vbno then

Cancel=True
Me.Undo

End if

This is a little help with the code that you can put. Only see in VB help about msgbox

:)
Oct 8 '06 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by InDeSkize | last post: by
5 posts views Thread by Aspnot | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
2 posts views Thread by Marin | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.