Hi All,
I am looking to filter my subform records. Maybe.
I have two fields:
RER Number
Serial Number
My subform shows the RER Number of all the records in which that Serial Number has been entered before. However it shows the current parent RER Number also. I tried applying a filter to the subform:
But that then prevents any records being shown in the subform.
Any help is appreciated!
I am looking to filter my subform records. Maybe.
I have two fields:
RER Number
Serial Number
My subform shows the RER Number of all the records in which that Serial Number has been entered before. However it shows the current parent RER Number also. I tried applying a filter to the subform:
Code:
Me.Filter = Me!RER_Number <> Me.Parent!RER
But that then prevents any records being shown in the subform.
Any help is appreciated!