Need help with filtering form code

[bgeorge12]

I have a form that is a data entry form. I have learned how to switch it to a filter form by using the Sort & Filter - Advanced - Filter by form. To simplify this I would like to write code (attached to a button) that will do this feature and upon closing the form it returns to data entry again. The field on the form that I want to search by is [Customer ID]. The form name is [Order Details]. Any help will be appreciated. Thanks

 

[ted.martin]

This post should not be in Macros - rather Forms. Anyway .....

If CustomerID is an Integer number then:

Docmd.OpenForm "Your Form",,,"[CustomerID] = " & CustomerID.value

If CustomerID is Text then:

Docmd.OpenForm "Your Form",,,"[CustomerID] = " & CustomerID.value & ""

If CustomerID is stored in a string variable e.g strCustomer then:

Docmd.OpenForm "Your Form",,,"[CustomerID] = '" & strCustomer & "'"