Good morning,
I have a field in a table that is hidden. (It doesn't show up on any queries or forms.) I have the default value as "Date()" so that it will put in the date that the record is created. This works good, but I want to go up another level...I want that field to also update to the current date each time that record is modified. Is this possible? And if so please help me to understand how to accomplish this.
I appreciate any help anyone can give. :D

Regards,
Laura

The only thing standing between you and your goal is doubt. Quit doubting yourself and you'll be able to accomplish anything!

__________________
Regards,
Laura

The only thing standing between you and your goal is doubt. Quit doubting yourself and you'll be able to accomplish anything!

Laura,

Try the following:

Private Sub Form_AfterUpdate()
   me.datefield = date()
End Sub

Change 'datefield' to your control's name.

Regards,

Beth M

Hello Beth,
Thank you for the reply.
I tried this and I get a message stating that an error has occurred and it cannot save the record at this time. Then asks if I want to close the object anyways. Does it matter that my form is a in a datasheet view and not one record per page?


Regards,
Laura

The only thing standing between you and your goal is doubt. Quit doubting yourself and you'll be able to accomplish anything!

It doesn't matter what the view is, form or datasheet. But please provide more details about the data. Is the form bound to a table, query or was it a recordset returned by entering criteria in an unbound search?

Sorry it took so long to reply...It has been a real hectic week!
TGIF!!!
I created a query based off my table simply for sorting purposes then based my form off the query. It's not a recordset at all...(I'm not very good at those just yet.) I do have a couple of combo boxes that are drop down lists based off of two other separate tables, but I wouldn't think that would matter.
If this isn't enough info or you need me to e-mail the database, please let me know.
I appreciate your help!

Regards,
Laura

The only thing standing between you and your goal is doubt. Quit doubting yourself and you'll be able to accomplish anything!