L
LindaL.
1 problem solved thanks to ya'll and another pops up.
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 with 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 have a dropdown box that
will list the rooms (using a query) I have selected in the
previous subform.
My problem is I need to go 1 step further. I have a
subform using tblWindows (Primary key RoomWindowID)that I
would like to link up to the rooms in the combo box on
Page 2 so when I choose the room I need only the records
in the tblWindows that are associated with this particular
room.
Sorry to ramble on. I just want to make sure this is
understandable.
Any help would be greatly appreciated
Linda L.
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 with 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 have a dropdown box that
will list the rooms (using a query) I have selected in the
previous subform.
My problem is I need to go 1 step further. I have a
subform using tblWindows (Primary key RoomWindowID)that I
would like to link up to the rooms in the combo box on
Page 2 so when I choose the room I need only the records
in the tblWindows that are associated with this particular
room.
Sorry to ramble on. I just want to make sure this is
understandable.
Any help would be greatly appreciated
Linda L.