By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,971 Members | 1,594 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,971 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

P: 143
Therre is no easy answer to this one. Have a look here
May help
Oct 5 '06 #2

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


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.