Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2011
    Posts
    1

    Question Unanswered: Access filling multiple fields from single source

    Hi all, hoping for some help.

    I have a database that records production data. Within it are 3 fields for selection of products made on a single line, each of those fields is a lookup to a table that contains the product data.

    On the main form is a field for Product 1, 2 and 3. What I am trying to do is then have a field that selects the relevant description of that particular product from the products table. However, Access seems determined to only let the Description box show data for Product 1. I am sure there is something really obvious we are missing but we're certainly not experts on this.

  2. #2
    Join Date
    Mar 2009
    Posts
    5,441
    Provided Answers: 14
    1. Is the form bound to a data source and, if it's the case, is the control you name Description in your post bound to a column of the data source?

    2. How do you adjust the form to the data it is supposed to display after having selected the products?
    Have a nice day!

Posting Permissions

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