Howdy, Stranger!

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


LIKE Operator in MS Access 97

urbanurban Member Posts: 11
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! :)


  • nwdurcholznwdurcholz Member Posts: 3
    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.