How to collect date and time to database?

I have a form for customer to fill and when I build display the data page. I want to able to get the date and time that the customer filled that form


Sean

Create a field in the database table called SubmitDate, or whatever you want to call it, then make the default value for thr field getdate() if you're using SQL Server or Now() if you're using Access.

Whenever a new record is inserted into the table the SubmitDate field will be filled with the current server system date.

Regards

Owen.

Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo

Thankyou

In past projects, I've seemed to need the date and time in separate fields in my access db. I ended up using Date() and Time() as the default value.

Ken