I have a form which contains 3 subforms. On the main form is a combobox field and the default value of the combobox field is:
The first thing a user does is attempt to make an entry in one of the subforms. But because the user doesn't actually do anything with the main form (unless they select a different username from the combobox), they get an error because the main form record hasn't actually been created. In other words it doesn't have a record number yet.
What I need to do it "trick" the main form into creating a record once the user focuses on the subform.
How can this be done?