VB 2005 Parameter Query
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