Results 1 to 3 of 3
  1. #1
    Join Date
    May 2014
    Posts
    3

    Unanswered: Update Form field based on query result

    I have a database that will be tracking customer complaints.

    I want the user to enter the customer order number on the complaint data entry form and have the Customers ship_to_ name (stored in another table) pulled back into another field on my form (Customer Name).

    I have a query to run and get the proper data quickly but I cant get it to populate the Customer Name field on my form.

    I tried a Dlookup and it just takes too long and craps out due to the table storing the order information having over 60,000 records.

    Does anyone have a better way to look up the customers ship to name in another table based on on the order number entered on the data entry form AND return it back to the Customer Name field in the form?

    And help would be appreciated.

    Regards,
    KW

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    Use a query associating both tables
    Have a nice day!

  3. #3
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    495
    Provided Answers: 24
    Use a subform for Client based on a query. That query is based on what the user picks in the combo box. When the user updates the combo pick, refresh the sub-form.
    All the data will fill in.

Posting Permissions

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