LIKE Operator in MS Access 97

To use a LIKE operator in a Filter statement in Access?

For example in the OpenForm command, the Filter is: [Registration]=[Forms]![SearchbyReg]![txtReg]

How would i make it a LIKE operator? Or can i use a normal SQL statement, and how would i open the form using that?

Thanks! :)


  • You use it exactly as you would in a query: [Registration] Like [Forms]![SearchbyReg]![txtReg]. Filters are constructed the same and behave the same as SQL WHERE clauses. The only difference between them is that in a filter, you don't need the word "WHERE".


Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!


In this Discussion