I have a search form with a query-linked subform.
One of the fields in the subform are date fields.
Is there a way to autopopulate the DateFilled field when the person
enters the field? I need this to be code which is entered into the
form, rather than as a property of the field in the table because
there is other data which is entered before. This data is entered in
at a later date.
example
OrderNum ProductName Qty DateOrdered DateFilled
---------------------------------------------------------------------------------
439 Round To-it 3 2/2/2001 N/A
440 Round To-it 2 2/12/2001 2/2/2002
441 Round To-it 4 2/18/2001 =Date()
where record 441 is the one being entered in the subform.