Adding Wildcard

  • Thread starter Thread starter Daniel
  • Start date Start date
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
 
Back
Top