Hi June,
Isnt the filter called strWhere?
Hi June,
Isnt the filter called strWhere?
No, that is just a variable holding string to facilitate building criteria to set Filter property. That variable is only available for reference in the button click procedure it is declared in. Since you want to open second form via a different button click, reference the form's Filter property to retrieve the criteria.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Ok. Makes sense. Thanks again June!