filter from combobox

[Joe Z]

I am trying to filter data from a table by selecting criteria from a combobox.
table: tblBillVendor
form: frmMedVendor
query: qryBillVendor
combobox: cmbVendor

The source for the form frmMedVendor is qryBillVendor; the source for cmbVendor is an SQL with ID as column(1) which is the bound column. I have tried setting the where row in qryBillVendor.ID to Me.cmbVendor but the query does not get updated.
What I am trying to do is select a vendor on the main form so I can review data in the linked subform. The query does not update.
Questions: How do I update the query so main form will update?
How do I requery so all records will show?
I guess I am not sure how to reference the different queries & forms?
Thanks

 

[jackd]

There are several good tutorials at http://www.datapigtechnologies.com/AccessMain.htm
Good luck

 

[Joe Z]

Thanks, the info was helpful. It's working now but I am getting the "Enter the parameter dialogue box" so I must have a problem with expression so I need to do a little fine tuning.