Adding a autotime when a record is added.

[Guest]

I have a tabular form that many users use and would like to have a area that
records just the time the record was added(the date is in another box) and
adds that to the table so I can use this infromation in a query. Is there
any way to do this.

 

[Guest]

separating the date from the time is not a very good idea. It will cause
more problems than it solves; however, the easy way to do it is create a text
box on your form for the time and make Time() the Default Value.

 

[Guest]

I understand the problem that might arise donig this but willing to work with
them.

But when ever I use the =Date() or =Time() it works but when I close the
form and open it goes to the current time when the form is opened. i want
it to stay at the time when the record was orginally entered.

Thanks
jshb4mrgn

 

[Guest]

Are you using the Default Value property or the Control Source property?
The Default Value property only applies to new records. The existing
records you created in the previous sessioin should remain as you entered
them.
Is it possible you don't have this control bound to a field in the record
source?