Results 1 to 2 of 2
  1. #1
    hallednurse is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    May 2020
    Posts
    1

    Continuous form combo box auto-fill issue

    I have a continuous form with two combo boxes. I would like the first combo box to dictate the data shown in the second combo box. Right now, when the customer name in the first combo box is selected, the second combo box displays the ID value for that row in the table and it should show the customer's email address.



    The control source for the email combo is set to customer name and row source is as follows: SELECT tblRecipients.Email FROM tblRecipients.

    Any idea why ID is pulling up rather than email? Thanks in advance.

  2. #2
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 10 Access 2016
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    Replace the second combo with a text box.
    Add the email field to the SQL statement used in the first combo. This can be hidden by setting the Column Widths and Column Count properties of the combo.
    Set the Record Source Property of the text box to:

    =[ComboBoxName].Column(1)
    The columns of the combo numbered starting with 0, so the first column is (0), the second is (1) etc
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Auto Fill Fields in a Form using a Combo field
    By jlindquist23 in forum Access
    Replies: 9
    Last Post: 03-14-2019, 10:55 AM
  2. Replies: 3
    Last Post: 06-09-2013, 05:35 PM
  3. Replies: 11
    Last Post: 01-25-2013, 12:03 PM
  4. Replies: 3
    Last Post: 03-21-2012, 01:43 PM
  5. Auto Fill Issue #2
    By Swilliams987 in forum Database Design
    Replies: 9
    Last Post: 01-21-2011, 03:52 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums