Hi,
I am new to Macros for Access 2010. I am trying to build a simple text box which allow user to add multiple keywords (i.e. bills, billing, bill) for search within a text field. I cannot use VBA code, because I will am building this form to publish on sharepoint and VBA is not compatible only Macros are compatible.
I can do that with VBA to generate a query with multiple criteria for where clause, but don't have luck with building same functionality with macros.
I have already done it with one keyword but not sure how to develop a macro with multiple where clause.
any help is really appreciated.
thanks