Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2006

    Unanswered: Help with populating Table

    I have a form that uses a requery macro to populate all the fields after the user types in an account number. All the fields are linked to a separate table, but unless I click on each field individually the information doesn't populate to the second table. Nothing I've tried seems to work. Any help would be appreciated.


    Last edited by CMUNIZ; 04-24-06 at 15:21.

  2. #2
    Join Date
    Nov 2003
    Welcome to dbforums.

    In the Unload event for your Form (assuming you are only working with one record in your Form) enter this line:

    DoCmd.RunCommand acCmdSaveRecord

    Self Taught In ALL Environments.....And It Shows!

  3. #3
    Join Date
    Apr 2006

    Still having the same problem...

    It's still doing the same thing. I input my account number, click the command button to run the requery , the rest of my fields populate from table 1 onto the form. Then I go to the next record or exit the form.

    When I look at my table 2 only the account number I typed is actually saved. Unless I click individually on the fields. Then if I open table 2 all of the fields will have the appropiate information.

    So it's populating correctly it just won't see the information to populate unless I manually give focus to the fields after they have been updated in the form.

    I've tried the Getfocus command but even thought it moves the cursor to the field it won't transfer the information to table 2 until I physically click on it.

    I'm not sure what I'm doing wrong.

Posting Permissions

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