Getting the filter for (me.filter) to work with a string variable

[newsboy33]

I have automated a key word search on a field called capability name using the code:

Me.Filter = "[Capability Name] Like '*med*'"

I have several key words like med above but the number is growing and the initial few filters will eventually become an overwhelming number of option boxes. What I have done is placed the key words in a table, display them via a combo box and have user select the key word by clicking on one of the rows displayed, on click this should save the value to a string variable Keyword1. I use the code:

Keyword1 = Combo79

But all attempts to insert a the variable Keyword1 in place of the med above fail to yield a filter which will display any records, am I trying to do the impossible? How do I reference the variable, or would someone recommend a different methodology

Thanks

 

[KenReay]

Hi

How about:

Me.Filter = "[Capability Name] Like '*'" & Combo79 & "'*'"


Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[newsboy33]

Thanks: I had to eliminate the ' before the "& and after the & " to get the value to balance to the previous expression and it works...