On a form in Access, how do I make one list drive the options ava.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to be able to have the selection in one list drive the options
available in the next selection list. How can I do this?
 
Hi, Winkleby.

In the AfterUpdate event procedure of the first combo box, set the RowSource
property of the second, using a WHERE clause that refers to the selected
value. Something like:

MySecondComboBox.RowSource = "SELECT MyTbl.ID, MyTbl.Desc from MyTbl WHERE
MyTbl.ID = " & Me!MyFirstComboBox.Value

Hope that helps.
Sprinks
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help With MS Access 4
Access 2003 Data Not Saving? 0
Googles data cap will be effective from June 1, 2021, are you prepared? 3
What are the steps to fix damaged MDF files in SQL Server? 0
Show me your highest mileage HDD? 0
options group can only select one option? 9
first listbox populates second listbox and allows multiple selections 1
How can I migrate MBOX to PST? 2

Back
Top