Turn off Filter when a Form is Opened to Specific Record
Posted on 2006-05-09
I have a continuousform with a list of customers. When i double click a customer name, I am using thecode below to open a form to a specific customer
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "AddCustomer"
stLinkCriteria = "[CustomerNo]=" & Me![CustomerNo]
DoCmd.OpenForm stDocName, , , stLinkCriteria
This opens the form to the desired customer - filtered
How can I turn off the filter if the user wants to see the other records.
I have another button on a Menu that opens the customer form unfiltered. But, once the form isopened filtered, it must be closed, then reopened using the button on the meun to see all customers.
Thanks - AB