Coding Question

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

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
 
Sky said:
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.
Click to expand...


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