Save/Write record while still in form

[tkhouk]

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

[comteck]

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