Results 1 to 3 of 3
  1. #1
    Join Date
    May 2005
    Posts
    54

    Unanswered: Add New Record Question

    I attached my database for easier reference.

    In the database I created, there is a form called frmCustomer.

    When I click on the Add/Print Bank References toggle button, it opens another form called tblCustomerBankReferences.

    I can add a new Bank Reference and return to the frmCustomer. But when I click on the Add/Print Bank References toggle button again, the new reference I just added is not in there.

    What am I missing?

    Thanks,

    Mary
    Attached Files Attached Files

  2. #2
    Join Date
    May 2005
    Posts
    54
    I figured out that it is in the code for the toggle button under the FilterChildForm section of the VBA code. But I'm not sure how to fix it???
    Last edited by somthinboutmary; 05-09-07 at 13:43.

  3. #3
    Join Date
    Nov 2004
    Location
    Harrogate, N.Yorks, UK
    Posts
    83
    On your open form event the code should read something like

    Code:
    DoCmd.OpenForm "frmCustomerBankReferences", acNormal, "", _
        "[CustomerReference]=[Forms]![frmCustomer]![CustomerReference]", acFormEdit
    where [CustomerReference] is whatever your primary key is on the tblCustomer.

    To avoid confusion you should also avoid naming your form with the tbl prefix which Access gives it on creation- unless that was a typo.

Posting Permissions

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