open text or number criteria

[ariansman]

I'm using a control on a form as a parameter for my query. I've defined the criteria in the query as
[Forms]![myform]![myControl]
How do I set this up so that the query returns all records which have a part of the myControl that is typed in [myForm]![myControl]? does this work for both number and text?

Thank you

 

[boblarson]

I'm using a control on a form as a parameter for my query. I've defined the criteria in the query as
[Forms]![myform]![myControl]
How do I set this up so that the query returns all records which have a part of the myControl that is typed in [myForm]![myControl]? does this work for both number and text?

Thank you

Like "*" & [Forms]![myForm]![myControl] & "*"

 

[KenHigg]

What is the data type of the column you have the criteria on?

 

[ariansman]

tnx a lot , it worked
in one column it is number, in the other column it is text. do they make