MS Access Question

[Megadeth]

OK! I must just be stupid or something but here is a question for all of you.

I have a table with a field that uses date/time... This field needs to include the time that a call is made.... So... I am using the Now() expression as a default value on the date field.

I thought would be fine except that I am finding that when I go to the next record the date is only accurate if the user enters information right away....

In other words if they get a call and and fill out the form then click to the next record on the form the date will be auto filled in which would be fine if they have another call to document but it is not fine if they leave the window sitting there for several minutes.

I was simply trying to make a button so that On Click it would update the time in the field on that table! Unfortunately I keep hitting errors trying to do this even though it should be easy right?

I'm wondering now if I can even do this... Any ideas?

 

[theknight571]

On that button that creates the new record you could attach the code that sets the time:

i.e. (in pseducode )
...
open form for new input
Form.DateField.Value = Now()
...

Don't use the field's property to set the date...or it won't get "set in stone" until the record updates, which isn't until you move to the next record or open a new one.