Adding Wildcard

D

Daniel

How can I add a wildcard character to the end of a selection from a combo
box?

Example: I have a query based on criteria selected from a combo box,
[Forms]![FormName]![Combo1]. If "ANYVALUE" is selected from the combobox,
then I want to add an "*" to the end so that with my LIKE statement, it
selects everything that starts with that "VALUE".

Thanks,

Daniel
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combo box 0
Coding wildcards in search criteia 2
Combo is null 4
synchronize combos 5
Combo - If Not in list Open a Form 0
Find/Replace MSWord wildcard characters from within Excel 6
stlinkcriteria syntax. multiple fields and wildcards 5
Formating bolded text exclusively. 0

Top