Hi newbie macro question

[yepwingtim]

I'm trying to set a date/time.
When someone calls in the date and time will be recorded.

i did this using setvalue date() and setvalue time()

The problem is when i change or edit the record,
the date and time will adjust because of the macro.

Is there a way to set the date and time only once and then turn the macro off?

Thanks guys
________
Mercedes-benz w212

 

[yepwingtim]

would IsNull([DateMod]) and IsNull([TimeMod]) be correct?

Or should i put more conditions
________
You porn

 

[boblarson]

1. you should store the date/time in ONE field instead of two.

2. You can use =Now() in that field's DEFAULT VALUE property at table level and a new record will always insert the current date/time and only for new records.