Date problem

[kryten]

Hi everyone,

I currently have a form with a date field, the control source for which is set to =Now(). This shows the current date, which is what I wanted, however, the date field is automatically updated every day with the new date, so that all records show todays date even though the record was saved on a different date.

How can I save the current date for the date the entry was made?

Thank you in advance.

 

[KenHigg]

Sounds like you need to set the default value of the textbox to now() and set the controlsource to the date field in the underlying tabel...


???
ken

 

[kryten]

Thanks Ken - again!

Do you know of a way to put a command button onto a form that allows the user to input the current date by clicking it?

 

[Mike375]

Thanks Ken - again!

Do you know of a way to put a command button onto a form that allows the user to input the current date by clicking it?

A SetValue macro action.

Item [FieldName]
Expression Date()

If the form for the date insert is not the active form then change Item to

[Forms]![FormName]![FieldName]

The macro goes on the OnClick event of the button.

Ken can do the code version

Mike

 

[kryten]

Thanks Mike - worked a treat!