Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2012

    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.

    thanks a lot!

  2. #2
    Join Date
    Jun 2005
    Richmond, Virginia USA
    Provided Answers: 19
    Hope this helps!

    The problem with making anything that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts