combo to filter subform from another subform

[projectpupil7]

Hi All,

Main form frmSiteDetails

frmRooms (subform) holds Room information for the rooms on each floor. This form has LinkMasterField [SlaveFloorsID] and LinkChildFields [FloorsID]

frmFloors subform holds floor information for each floor in a property. This form has LinkMaster [SiteID] and LinkChildFields [SiteID]

Both these forms sit on a Tab Control (TabCtl57) and do work properly.

What I would like to do is to also have a Combo to pick a floor number from frmFloors and filter frmRooms. Both these forms have FloorsID fields. This would save a user having to go back to frmFloors to pick a different floor and then go back to frmRooms to view the room data for the new chosen floor.



I am searching for a solution at the moment but haven't yet found one.

Could someone help me to code this or perhaps point me to an example.

[NTC]

the sub forms each have a record source (table or query) - a query can have a criteria which determines which records are in the query result. good so far?


that criteria can be called from a field in an open form i.e. Forms!SiteDetails.ComboboxName


the sub forms will not inherently know when the combobox (criteria for their record source) changes - so you must trigger the sub forms to requery in the AfterUpdate Event of the combobox i.e.: Forms!frmRooms.requery


these are the principals around what you seek.

[projectpupil7]

All the subforms are actually based on their tables.
At present i have cboChangeFloor sitting on the Main form frmSiteDetails. The combo is based on a query qryChangeFloorNumber, the combo displays correctly.
On frmRooms i have a field called FloorsID with a default value from =[Forms]![frmSiteDetails]![cboChangeFloor]. If i now change the combo i am getting "can't find frmRooms". This is in the AfterUpdate of the combo Forms!frmRooms.requery.