I have a main form, building, a subform, floor (linked one to many with buildings) and a second subform, room (linked one to many with floor

The link from the first subform to the second subform is:

[sfrmFloorDetails].Form![FloorID]

but, it's not picking up the FloorID number for the room table - any suggestions?