Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Update Combo boxes

Status
Not open for further replies.
Kib

Kib

Programmer
May 17, 2001
58
US
I have 2 combo boxes
What I want is:
After selecting an item in the first box, it to update the second box with only items that apply are associated with the first...

Not sure how this is done. Thanks
 
Sort by date Sort by votes
Put this in the Click event of box 1, Obviously you will have to change the SQL a bit.

Me!Combobox2.Rowsource = "SELECT * FROM Blah WHERE Blah = '" & Me!ComboBox1 & "'

Good Luck
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

monkeysee
  • Locked
  • Question
Combo Box - Limit results
Replies
1
Views
203
dhookom
dhookom
visitnag
  • Locked
  • Question
combo box entries problem
Replies
8
Views
185
visitnag
visitnag
JanaLNelson
  • Locked
  • Question
Filter as you type combo box in Access 2
2 3
Replies
54
Views
750
JanaLNelson
JanaLNelson
dhookom
  • Locked
  • Question
Make second combo box display records dependant on selection from first combo box 1
Replies
2
Views
139
dhookom
dhookom
TrekBiker
  • Locked
  • Question
Forcing Form Updates
Replies
2
Views
194
TrekBiker
TrekBiker

Part and Inventory Search

Sponsor

Back
Top