Linking combo box to subform

[LindaL.]

Page 1 of main form/with tabs lists information such as
address, city, etc. (Primary key is LocID). I have linked
a subform to it that has a drop down box so I can choose
what type of building is located at this address (Primary
key BuildingID). I have linked another subform to the
Building subform with a dropdown box (RoomID)that I can
choose what type of rooms are in the building (a.e.
livingroom, den, etc.)(Primary key BuildingRoomID).
On Page 2 of the form I want to have a dropdown box that
will list the rooms I have selected in the previous
subform. I have tried several different ways. I keep
getting a combo box that lists all rooms to several
locations. Can someone help

 

[Arvin Meyer]

Why not just put a copy of the subform that's on page 1, but this time, lock
or disable the controls so that they can't be changed?
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access