vba - Using parameter from a form as part of a "like" sql statement -

i have query this:

select name,label tablename label '*[form]![label search]![searchtxt]*'; 

i know query works in sense if replace "[form]![label search}![searchtxt]" actual word, query works. when run query is, data form doesn't go query no rows.

how can part of query work input form. realize require vba in addition sql.

thanks

you need concatenate asterisks in. like:

select name,label tablename label '*' & [form]![label search]![searchtxt] & '*';