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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Combo Box conundrum
The row source for the room combo box is: SELECT tblBuildings.pkBuildings, tblRooms.txtRoom FROM tblBuildings INNER JOIN tblRooms ON tblBuildings.pkBuildings = tblRooms.fkBuildingID WHERE (((tblBuildings.pkBuildings)=[forms]![frmAdd].[numBuilding])) ORDER BY tblRooms.txtRoom; the code for the...- jb1099
- Post #6
- Forum: Microsoft: Access Forms
-
Combo Box conundrum
Verified that event is on After update on the building combo box, but when room is selected from the list, still only selects first item in the list.- jb1099
- Post #3
- Forum: Microsoft: Access Forms
-
Combo Box conundrum
I am using two combo boxes to allow the entry of the location of an inventory item. The first combo box uses a query to populate all the building numbers. The second box will then allow the user to select only the rooms that are available from the first combo box selection. Combo box buildings...- jb1099
- Thread
- Replies: 6
- Forum: Microsoft: Access Forms
