Results 1 to 4 of 4
  1. #1
    martinwd is offline Novice
    Windows XP Access 2007
    Join Date
    Jun 2009
    Posts
    5

    Query based on Value in a Combobox

    I used to remember how to do this when I used Access97 but I have forgotton. I am currently trying to learn Access2007 and I am about to pull out what remaining hairs I have left. Here's the info. I have a form InvInputfrm that has a combo62. When I select the value in that combobox I want it to be the parameter for my select query. This result will then populate combo64 of the InvInputfrm. Then based on the selection of combo64 a textbox will be filled in with data from column (1) of that combobox. Any assistance that you can give would be greatly appreciated.

  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,912
    Sounds like a Cascading ComboBox to me.
    (RG for short) aka Allan Bunch Previous MS Access MVP - WinXP Pro, Win7 Pro Win10 Pro - acXP, ac07, ac10, ac13
    How to mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

  3. #3
    martinwd is offline Novice
    Windows XP Access 2007
    Join Date
    Jun 2009
    Posts
    5
    RG, thanks so much for the help. I knew it had to be something easy. I just couldn't remember.

  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,912
    You're very welcome. Glad I could help. Is it time to use the link in my signature yet?
    (RG for short) aka Allan Bunch Previous MS Access MVP - WinXP Pro, Win7 Pro Win10 Pro - acXP, ac07, ac10, ac13
    How to mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

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

Similar Threads

  1. query - criteria based on another row field value
    By techexpressinc in forum Queries
    Replies: 1
    Last Post: 05-29-2009, 04:17 PM
  2. Form Based Query/Filter
    By Micon in forum Access
    Replies: 0
    Last Post: 11-07-2008, 09:25 AM
  3. Replies: 0
    Last Post: 04-17-2008, 09:24 AM
  4. query based on two combobox
    By datto in forum Queries
    Replies: 0
    Last Post: 04-18-2007, 11:10 PM
  5. Run a PivotChart form based on query
    By Suzan in forum Queries
    Replies: 0
    Last Post: 06-11-2006, 03:48 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 - Senior Forums