link a txtbox with a query

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

Guest

Hi guys, I am working in an Access Project and I want to connect one textbox
I have in the form with the criteria in the query (View) for the row source
for a combo box in the same form, what I want is for reduce the amount of
records shown in the combo box. I typed this lines in the criteria of the
fieldcategory in the query,
= [forms]![frmPopAddProductOrRecipe]![txtCategory]

but it doesn't recognize it.
 
Hi Orlando

The combo box needs to be requeried whenever your text box is changed. Use
the After Update event of your text box like...

Private Sub txtCategory_AfterUpdate()
Me.comboBoxName.Requery
End Sub


Regards

Andy Hull
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

combo box selection will not populate query correctly 1
How do I use a form to run a query? How do I bind the query to it 2
Using combo box selection to supply criteria for query 25
How do I use a combo box to filter a query's results in my form? 14
Linking subform. 1
Using Between criteria to search query 1
Specifying conditional Criteria in a Query or Report 6
filter query on combo box in a continuous subform 0

Back
Top