Coding Question

[Guest]

Hello All,

I have text box named "UserInput" that needs to lookup whatever name the
user types in then display all records related to the name they type. The
names are based on a field called "Producer" that's in my table called
"Application".

The text box calls a query named "ProducerQuery", but that's where I'm
having difficulty. Can't figure out how to tell the query to look up what the
user typed in.

Can anyone show me how to code this?

-Sky

 

[Marshall Barton]

I have text box named "UserInput" that needs to lookup whatever name the
user types in then display all records related to the name they type. The
names are based on a field called "Producer" that's in my table called
"Application".

The text box calls a query named "ProducerQuery", but that's where I'm
having difficulty. Can't figure out how to tell the query to look up what the
user typed in.

Typically, you would just add a criteria to the query that
references the text box on the form.

Under the Producer field in the query, try using:
Forms!nameofyourform.UserInput

That should find the records that match the text in the
UserInput text box. If you don't want exact match, then
explain what you mean by "related to the name they type"

 

[Guest]

Marshall,

Thanks very much. I used your suggestion and it works great. You Rock!!