Auto Date / Time fields

[Guest]

I am working on a database for a remote warehouse. I need to have several
Date / Time field autocompleted when the coresponding check box is checked.
below is a sample of data.

tbl tickets
*ID (autonumber PK)
ordernumber
date order printed (Date/Time)
orderreceived (Check box)
date order received (Date / Time)
order shipped (Check Box)
date order shipped (Date/Time)

I need the three Date / Time fields to auto complete when the data entry
occures in the ordernumber field and when the check box is check for order
received and order shipped.

Any help through VBA or Form coding would be a great help!

Barry

 

[David F Cox]

If you set the default value of the date fields to DATE() they will be
generated ready for the the new record to be created.

 

[Guest]

I can do this for the ordernumber field (which creates a new record), however
the other fields (date order received and order shipped) would need to be
completed when the coresponding check box is checked. I would like to keep
all this in one record. instead of multiple tables.

Barry