L
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
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