Dates in two different fields on same tbl

[JSD]

Hello

I've been trying to rework an old database.

One tbl has a 'DateIn' field and a 'DateOut' field. When user adds a record to this tbl (through a frm), the 'DateIn' field defaults to the date of the add.

Through a different frm I'd like to update other fields in the tbl, and have the 'DateOut' default to the date of the update. However, I can't use =Date() because it is already being used as a default value in the 'DateIn' field. I was told I could put =Date() in the BeforeUpdate property for the 'DateOut' field on the frm, but that didn't work.

Any suggestions, or do tbls just need reconstructed. Any advice would be interesting and helpful.

THanks

Jeremy

 

[KenReay]

Hi

First I do not follow your logic of why you cannot use =Date(), just because it is already being used in another field.

=Date() returns the system date at the time the command is executed, you can use it as often as you like

But since you (presumably) only want to update the DateOut when a record is updated, I would say you need to put

DateOut = Date()

in the before update event of the FORM


Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK