Unanswered: Subform - add new records causes duplicates, not working
My form has one unique identifier, a combo box. The user chooses a selection on the main form combo box.
My subform has 2 combo boxes and 2 text fields.
Users choose a selection from a list in each combo box. Then enter text in the text fields.
There will be multiple records entered on the subform for each number chosen on the main form.
When I try to enter records in the sub form, its creating multiples records that are all the same. These records show on the form. But are not saving to the table.
I'm not an expert in sub forms and how they work. Are they supposed to automatically allow new records to be entered?
I put in a "Add New Record" command button and tried various code behind it, such as
DoCmd.GoToRecord , , acnewrecord
and setting focus to the first combo box in my sub form.
But I can't get the form working correctly.
It should be a pretty simple straightforward form with subform.
Does anyone have a link to info creating a subform, and what properties I should have selected.