Convert NOW()

I need to convert the system date NOW() in an Access database field to a static date. The field shows the system date, but whenever the record is opened again it naturally reflects the current date. I need to have the system date picked up, then copied as a static value in the same field. I need to perform calculations based on the static date. Help!!

Thanks
McDee

re: Convert NOW()

Is the textbox's Control Source assigned to the field in question (Do not use =NOW for the Control Source of the textbox). Using the OnFocus Event for the textbox, you can use the following code:

Me.textbox1=NOW()

This will assign the current date to the textbox only when it has focus.

Not sure if this is what you're looking for.
comteck

re: Convert NOW()

I'll give that a try, thanks, I'm no expert here (obviously)!

McDee