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 Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Dependent Listboxes

Status
Not open for further replies.
Mr2006

Mr2006

Technical User
Jun 21, 2006
80
US
I have one listbox dependent on other. I want to be able when I click on the the row in the first list box, it shows the records related to this row in the second listbox. Right now, it will not do it unless I click on the second listbox. Note: the listboxes used to be combboxes depoendents. The VBA code I have is on got focus event.

Any suggestions?

Thanks
Mr.2006
 
Sort by date Sort by votes
Use the AfterUpdate event of the first list box to change the Rowsource of the second listbox.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

BlueHorizon
  • Locked
  • Question
Access 2010 Form w/Dependent Combo Box - How to Query on that field?
Replies
2
Views
59
BlueHorizon
BlueHorizon
44nato44
  • Locked
  • Question
Unable to display controltipstext on all listboxes 1
Replies
2
Views
40
44nato44
44nato44
Igawa29
  • Locked
  • Question
Dependent Box Question Help
Replies
6
Views
41
Igawa29
Igawa29
keun
  • Locked
  • Question
Combobox which is dependent on another combobox is not working?
Replies
5
Views
44
PHV
PHV
Jamie89
  • Locked
  • Question
Dependent combo boxes
Replies
8
Views
51
jeffshex
jeffshex

Part and Inventory Search

Sponsor

Back
Top