Combo box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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*"
 
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...
 
Back
Top