Results 1 to 6 of 6
  1. #1
    SGrohola is offline Advanced Beginner
    Windows 10 Access 2013 64bit
    Join Date
    Mar 2017
    Location
    Romulus, MI
    Posts
    41

    Question Problem with query, multiple tables and combo boxes

    I have a database that has multiple tables, and combo boxes. I have created a form, off of a query, and the query has multiple tables to pull data from. If I do just one table in a query and run the query, my combo boxes work fine. But, when I add another table to the query and just a few fields, my combo boxes stop. They will drop-down, but will not let me select any of the choices.



    It's doing this whether I have a value list or if I have the combo-box linked to another table.

    I do not know why this isn't working. And I don't want to have to put everything into one table to get it to work if I don't have to.

  2. #2
    Bulzie is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,463
    See if you have a field bound to the comb box(is the Control Source blank or no)?

  3. #3
    SGrohola is offline Advanced Beginner
    Windows 10 Access 2013 64bit
    Join Date
    Mar 2017
    Location
    Romulus, MI
    Posts
    41
    The 2 tables that have combo boxes are all bound. The other 2 tables have no combo boxes in them. The 2 tables that have no combo boxes, have a one-to-many relationship with the main (parent) table. The other table that does have a few combo boxes, is a one-to-one relationship with the main (parent) table. I could have swore this was working before I started creating the form.

    If I go into each table, the combo boxes let me pick any of the selections. It's when I get to the query, that I'm having problems.

  4. #4
    Bulzie is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,463
    Go into Design of the Form(forget the tables for now), then click on that combo box field in the form design. Go to the control source in properties and is it blank?

  5. #5
    SGrohola is offline Advanced Beginner
    Windows 10 Access 2013 64bit
    Join Date
    Mar 2017
    Location
    Romulus, MI
    Posts
    41
    Nope.... none of the combo boxes are blank. They all state the field that they are bound to. I can see every drop-down list, it just won't let me select any of them. Only at the table level.

  6. #6
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    Your query is not updatable.

    One table > One form.

    Use form/subform arrangement.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Replies: 5
    Last Post: 09-22-2016, 08:42 AM
  2. Search Query Based on Multiple Combo / Text Boxes
    By ItsJustRey in forum Queries
    Replies: 5
    Last Post: 07-20-2016, 02:04 PM
  3. Replies: 4
    Last Post: 10-09-2013, 03:44 PM
  4. Replies: 3
    Last Post: 03-01-2013, 05:36 PM
  5. Replies: 3
    Last Post: 01-30-2012, 09:43 AM

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