By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,652 Members | 1,468 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,652 IT Pros & Developers. It's quick & easy.

Data Entry Form: Save Button

P: 1
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
Share this Question
Share on Google+
2 Replies


100+
P: 143
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
Expert 100+
P: 1,418
PEB
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.