Using a Form to fill in Parameters - Text box?

[lmonroe]

I've been trying to figure this one out, and I'm not sure if it's possible, but rather than create a combo box for the form can I get this to work with just a text box? I have not had any luck thus far.

I want it to be like when it asks for a parameter value, and you just enter something rather than having to create a drop down list.

 

[boblarson]

You would reference the text box in the query like this (in place of the parameter prompt):

Like [Forms]![FormNameHere]![TextBoxNameHere] & "*"

That's for matching the first characters of what you want.

 

[lmonroe]

I tried doing it the way you suggested and doing it without the Like and & "*" the first way just returned all of the database and the second returned nothing...

 

[boblarson]

I tried doing it the way you suggested and doing it without the Like and & "*" the first way just returned all of the database and the second returned nothing...

So, what datatype are we talking about here? What is the field in the query you want to return values based on the entry in the form? What I posted was for a text field.

 

[lmonroe]

I have a bunch of Vendor Names, just a normal text field entry. I tried typing in Dell into the text box and got the results I described.

 

[boblarson]

I have a bunch of Vendor Names, just a normal text field entry. I tried typing in Dell into the text box and got the results I described.

So, did you type Dell into the text box and then move the focus out of the text box? If not, the text box wasn't updated yet with the value so it still had the value of null which is why the Like and "*" brought back all records and without it nothing came up.

 

[lmonroe]

That was it! Thanks!