Recent content by wbheath

Thanks that seemed to work. I did however find that the person who originally made the database had =now() beside time in the query field, that was probally screwing it up too. Thanks for all your help!

In the report the box shows "Time" (the name of the field) and the control source is "time" as well. I'm hoping just to have the =now() function only change once the form is made and never again. But everytime I access the record that time stamp changes. Sorry i can't upload the file...

Ok i'm having a similar problem with my auto date but this time it is when I print. I have a field for my date/time created, the default value is "=now()" this works fine but when I print it uses the current time and not the time that is in the form. The form always stays on the date/time...