Multiple Keyword Search Access 2010 Macros

[waseem82]

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

[CJ_London]

I don't use macros so it may be it is not possible, but would suggest that you have to build it in one 'hit'

something like if your one keyword solution which works is

myfield like *keyword1*

then for three keywords

myfield like *keyword1* or myfield like *keyword2* or myfield like *keyword3*