Results 1 to 4 of 4
  1. #1
    Delta729 is offline Advanced Beginner
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Nov 2010
    Location
    Los Angeles
    Posts
    95

    Auto Fill combo box for select qry from selecion of two other combo boxes

    I've been searching the web the last two days and found several articles that sound like they'd work, but don't. I'm completely lost... I have a data base I'm making for quality control.



    What I'm trying to accomplish is to have two combo boxes on a form whose selections would then filter a third combo box. My primary table is named "QC Table". I have two other tables linked on a 1to1 match; "AOR" and "Confirmation Type". I am trying to build a form where I can select options from combo boxes "cboAOR" & "cboConfirmatiionType" and then have these filter for only the data that matches from my selection query "Query Review" which pulls from my "QC Table".

    I hope this makes sense and help would be greatly appreciated. Copy of the file is attached.

    Thanks, Dan
    Attached Files Attached Files

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    You posted an MDB file but your profile shows Access 2010 (version 14.0). ???

  3. #3
    Delta729 is offline Advanced Beginner
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Nov 2010
    Location
    Los Angeles
    Posts
    95
    Oh sorry, I should have specified that. This is for work. I have Access 2010, however they haven't updated everyone yet to 2010 so I had to create it as an mdb. There will be two people using the file and both have 2003 version.

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Thanks. One mystery answered.

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

Similar Threads

  1. Replies: 5
    Last Post: 11-09-2012, 04:18 PM
  2. Combo Box auto fill and update table
    By memmons in forum Access
    Replies: 4
    Last Post: 09-27-2012, 11:58 AM
  3. auto fill text box from dependent combo box
    By tommyried in forum Access
    Replies: 6
    Last Post: 06-17-2012, 03:55 PM
  4. Creating a auto fill from a combo box
    By Trina76 in forum Forms
    Replies: 4
    Last Post: 02-07-2012, 02:43 PM
  5. Replies: 0
    Last Post: 06-29-2011, 01:04 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