System Date and Time

[rythem]

Hello,

I have a form that displays the system date and time for every entry.
When the data gets stored in the table, the date and time do not get stored. How can i save the date and time with all the other information.

Also, everyday when i open the form, it shows me all the data from the previous day but the date for all that data has changed to taday.
I want that everyday when i open the form, it should be blank and all data from the previous day must be stored in the table along with the date and time.

Hope someone can help me with this
Thanks

 

[KenHigg]

Can you simply add a field to your table and set it's default value to the current date/time using Now()?

 

[rythem]

that works

thanks a lot