Results 1 to 4 of 4
  1. #1
    googenfrog is offline Novice
    Windows XP Access 2003
    Join Date
    Jun 2009
    Posts
    2

    combo boxes

    Hello...can I get data from more than one table for combo boxes on my form. Currently I have textboxes and drop down combo boxes on my form. But when I use the form wizard I select more than one table but then when I go to create my combo boxes it only allows me to select fields from one table. Thanks

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    One table at a time maybe but a query can be the RowSource of a ComboBox and that query can join more then one table. I don't really understand your question.

  3. #3
    googenfrog is offline Novice
    Windows XP Access 2003
    Join Date
    Jun 2009
    Posts
    2
    I have textboxes and comboboxes on my form. If I put all my data in one table my form works fine but when I try to separate the one table into another table the form won't work. I'm using the form wizard and am able to select all the fields from each table. But when I want the combo boxes to work it's only showing tha data from the one table. I mean when I go into the properties dialog box for the source it only shows data from the one table. I'm not sure why.

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Any chance you could post your db so we can look at it? Remove any sensitive data of course. I'm still trying to understand what it is you need.

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

Similar Threads

  1. Combo boxes on a form
    By Maranna in forum Forms
    Replies: 1
    Last Post: 06-22-2009, 01:48 PM
  2. How to disable edit for combo boxes
    By access in forum Forms
    Replies: 3
    Last Post: 06-17-2009, 09:11 AM
  3. Help with Subforms/Combo Boxes
    By mikel in forum Forms
    Replies: 11
    Last Post: 06-03-2009, 07:45 AM
  4. combo boxes
    By labrams in forum Forms
    Replies: 0
    Last Post: 04-20-2006, 09:28 AM
  5. Combo Boxes
    By Mxcsquared in forum Forms
    Replies: 0
    Last Post: 01-19-2006, 04:59 PM

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