Saving new records with only default field values

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
 
A

Allen Browne

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Populate main form from subform record 0
Copy previous record into form field 0
Can't save record 4
Subform Issue - retrieving wrong record 5
Trouble associating parent form record to subform's record 1
First Subform record gets modified when closing form 3
Create subform default values based on value set in main form 14
Saving a record in subform 5

Top