Combo box

E

eb1mom

I have based combo box on value of text field. In criteria of query I have
this
[forms]![Myform]![MyTextField] which works IF values match exactly. But,
what I need is if text field value is A all records that have A or A* or
*A. I have tried many different bracketing and quote combinations for
criteria without success. Any suggestions would be appreciated.
 
M

Marshall Barton

eb1mom said:
I have based combo box on value of text field. In criteria of query I have
this
[forms]![Myform]![MyTextField] which works IF values match exactly. But,
what I need is if text field value is A all records that have A or A* or
*A. I have tried many different bracketing and quote combinations for
criteria without success. Any suggestions would be appreciated.
Click to expand...


I think this is what you're looking for:

LIKE "*A*"
 
E

eb1mom

Thank-you for your help. eb1mom


Marshall Barton said:
eb1mom said:
I have based combo box on value of text field. In criteria of query I have
this
[forms]![Myform]![MyTextField] which works IF values match exactly. But,
what I need is if text field value is A all records that have A or A* or
*A. I have tried many different bracketing and quote combinations for
criteria without success. Any suggestions would be appreciated.
Click to expand...


I think this is what you're looking for:

LIKE "*A*"
Click to expand...
 
Top