I am trying to change the source object of a subform on a mainform but need to go to a specific record when the source object has changed. The event is fired from the subform when a user clicks on a field I would like the subform source object to change and the record associated with that field to be shown on the changed subform.
So far I have used the following and I have tried everything this evening to get it working with little success. At the moment it throws up a error message method or data not found on Me.Subform which is the name of the unbound subform.
Any help would be much appreciated
Me.Subform.SourceObject = "subfrmGRMachineryDetails"
Me.Subform.Filter = "UnitID=" & Me![UnitID]
Me.Subform.FilterOn = True