insterting dates into a table

[tpowers]

Hello this may seem silly but I have created a form that the current data and time have displayed on the screen when the form loads. However I am having a problem with my queries and reports because the date that shows up on the screen does not appear in the table. Can any one help me with this.

The code that I am using in the form is DATE() and TIME().

 

[smoker1]

All you need to do is insert a Save DoCmd into your form's "on close" property.

 

[tpowers]

Ok, I tried what you said and I got an error.

This is the code that I entered for the on click event:

docmd.Save (acTable,clientEntry)

and I got this error:

Expected:=

can you tell me why?