G
Gary
I want to thank everyone for helping on my previous
issue .. as you would guess, I have another issue.
I have a form (formA) that has a subform (SF). SF
recordsource is a query (Q1) of a table. I would like to
filter the records on SF to show only records where a that
are a subset of another query (Q2).
When I try to link Q2 to the Q1 of SF, I'm not allowed to
edit the records in SF when FormA is open. My sense is
that the best way to filter these records is to use the
ApplyFilter feature.
Can anyone provide help coding this (VB or Macro) or
provide another suggestion?
Any help is welcome, thanks in advance!
Gary
issue .. as you would guess, I have another issue.
I have a form (formA) that has a subform (SF). SF
recordsource is a query (Q1) of a table. I would like to
filter the records on SF to show only records where a that
are a subset of another query (Q2).
When I try to link Q2 to the Q1 of SF, I'm not allowed to
edit the records in SF when FormA is open. My sense is
that the best way to filter these records is to use the
ApplyFilter feature.
Can anyone provide help coding this (VB or Macro) or
provide another suggestion?
Any help is welcome, thanks in advance!
Gary