Hi

Data Grid 1 contains a list of properties
Data grid 2 contains a list of rooms

I want the user to select a property from DG1 and then update dg2 with the appropriate rooms.

I can get the property id from DG1 but cannot find a way to change the recordsource for DG2 via code.

I also can't find a way to do (access psuedo code)
select * from rooms where [room id] = me.text1.text

that is a possible fix if I could figure it out.

Many thanks in advance
Mark