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!

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

Linking two combo boxes

Status
Not open for further replies.

Whittler

Vendor
May 26, 2003
2
AU
Hi, I am trying to link two combo boxes so that when I make a selection from the first, it will change the choice available for the second.
Thanks
 
Hello,

set the recordsource of your second combobox to
select .... from .... where ... = form_yourform.combo1.value

set the Enter event of your second Combo to

Private Sub combo2_Enter()
Me.ActiveControl.Requery
End Sub

that should work ..

Regards
Daniel

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top