Saving new records with only default field values

  • Thread starter Thread starter Ian King
  • Start date Start date
I

Ian King

This is something that's puzzled me for a while, but have been too
embarrassed to ask for help with!!

I have a main form called Audit, with a subform AuditDetail. The fields on
the main form can all be set to default values, eg Date(), Auditor,
AuditItem etc. However, I am unable to enter data in the subform until I
edit a field on the parent form.

Saving the record on LostFocus doesn't work - am I missing something?

TIA

Ian King
 
Ian, you need to dirty the new record in order to have something going,
e.g.:
Me.AutoDate = Date
Me.Dirty = False
 
Back
Top