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

Save/Write record while still in form

P: 4
I'm using Access 2003... I'm date and time stamping a record (to fields in a table) whenever it is accessed in the form and then the control is then sent back to the lookup box. While on the form, the date and time stamp happens, the record isn't actually written back to the table until I access a different record, or until I close the form.

My question... is there a macro command that will save the record back to the table immediately after time/date stamping it? I've tried the 'SAVE' action in various ways, but it doesn't seem to be working.

Any suggestions?

Thank you.

Kevin
Aug 14 '06 #1
Share this Question
Share on Google+
1 Reply


100+
P: 179
What do you mean by "the record isn't actually written back to the table until I access a different record, or until I close the form"?

How do you know this? The reason I'm asking is because in MS Access you are in real time, meaning that the data is put into the database as you type. If the table is open, you may not always see it immediately.

comteck
Aug 15 '06 #2

Post your reply

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