Results 1 to 3 of 3
  1. 05-20-2014, 09:22 AM #1
    behnam
    behnam is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    May 2014
    Posts
    72

    How to make the options of one combo box dependent on another?


    I have two combo boxes in my form. The first one has the option of selecting a or b. If the user selects a, the second combo box will have the options of c and d, if b is selected the options in the second one will be e and f. How can i do this?
    Reply With Quote Reply With Quote
  2. 05-20-2014, 09:35 AM #2
    June7's Avatar
    June7
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,602
    Review http://www.datapigtechnologies.com/f...combobox2.html
    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.
    Reply With Quote Reply With Quote
  3. 05-20-2014, 10:41 AM #3
    ranman256's Avatar
    ranman256
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,549
    after cboBox1 afterupdate
    it will do: cboBox2.requery (where the cboBox2.rowsource query has a reference to cboBox1 in it.)
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Do you know how to make options in form available only when checkbox is clicked yes?
    By xelloss100 in forum Forms
    Replies: 1
    Last Post: 08-07-2013, 11:31 AM
  2. Help make table with various options
    By tmcrouse in forum Queries
    Replies: 3
    Last Post: 04-26-2013, 09:59 AM
  3. Speed up Query AND Make a selection from given options
    By pimpzter in forum Access
    Replies: 12
    Last Post: 04-25-2013, 03:31 PM
  4. How make numbers (options 1,2,3) in table appear as text in forms (blue, green, red)?
    By malemozaffar in forum Forms
    Replies: 9
    Last Post: 11-23-2009, 09:20 PM
  5. combo box values dependent on selection another combo box
    By lrt in forum Forms
    Replies: 3
    Last Post: 02-26-2009, 10:17 AM

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
  •  

Forum Rules

Other Forums: Microsoft Office Forums