Form query subform

[Blondie96]

I know I have been at this too long... What seemed simple is now confusing me.

I have a form Which lists a type of room
cboroomtype (lg, med, tiny) This works

I want a subform (datasheet style) that will list all the room names of the
type chosen in the cboRoomType
The files look like:
Room Type:
roomTypeKey (autonumber)
RoomTypeName (Text)

Room Name:
1. RmKey (autonumber)
2. RoomType (links to RoomTypeKey of Room Type table), Number
Row Source: SELECT [Room Type].RmTypeId, [Room Type].RoomType
FROM [Room Type];
Bound Column 1, Col Widths 0";1" Limit to List: Yes
3. RoomName

Main Form has 1 field cboRoomGroup
Row Source = SELECT [Room Type].RmTypeId, [Room Type].RoomType FROM [Room
Type]; (this selects the room type correctly)


I have obviously set the form/subform up wrong. I have tried many ways to
setup the subform, but I'm obviously doing it wrong because no matter what I
select for the room type, the subform displays all the rooms in roomtype(1)
(or displays nothing at all) no matter which room type is selected

Any help will be appreciated.
Thanks,
Tamra