I have two forms both with a field [Group].
I'm in a record in frmAuditSchedule. I want to open [frmInputScreen] filtered on [Group] of the record I'm working on in frmAuditSchedule.
I tried ...
DoCmd.OpenForm "frmInputScreen", acNormal, , Forms![frmAuditSchedule]![Group]
but the form opens filtered but showing all records (not filtered on [Group]).
Any help would be appreciated.
I'm in a record in frmAuditSchedule. I want to open [frmInputScreen] filtered on [Group] of the record I'm working on in frmAuditSchedule.
I tried ...
DoCmd.OpenForm "frmInputScreen", acNormal, , Forms![frmAuditSchedule]![Group]
but the form opens filtered but showing all records (not filtered on [Group]).
Any help would be appreciated.