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

[bgeorge12]

Can anyone please help me?

[rpeare]

I would strongly suggest you stay away from creating and editing filters on forms with VB Code, especially when it is much easier to control what your users see with queries that you can alter on the fly.

That being said the code you're after is something like:

Me.Filter = "([tablename]![fieldname]= '" & Me![lookupfield] & "')"
Me.FilterOn = True
For a text field
Me.Filter = "([tablename]![fieldname]= " & Me![lookupfield] & ")"
Me.FilterOn = True
for a number field etc.

[bgeorge12]

Thank you, thank you!!!