Running a query based on a textfield-value in a form

  • Thread starter Thread starter Daan den Hollander via AccessMonster.com
  • Start date Start date
D

Daan den Hollander via AccessMonster.com

Hi,

I have a form with a hyperlink that opens another form to look in a
customer-table....

What I want is that the value of a textfield in the form called 'company'
is being used as the criteria for a query I run to show me companies the
contain what is entered in the textfield.
And after it has run the query it needs to show the results in a form
called Frm_company_search

Please help!

Thanks
 
If the field on form Company was [CompanyID], then in the query behind
Frm_company_search, in the CompanyID field, use this criteria...
=Forms!Company!CompanyID

Frm_company_search will open, displaying just the record with that CompanyID
value.
hth
Al Camp
 
Back
Top