Help filtering records

[Boz]

Hi...need a little help.

I have a table with the following fields:

Vendor
SKU
Description
Part Number
Unit of Measure
Buy Pack

I am trying to create a report that would allow me to select the Vendor from
a combo box then filter the records to only print the sku, descriptions, part
numbers, etc. for that vendor.

I've tried running a query, but I can't seem to get it right. Any help you
could provide would be greatly appreciated.

 

[pietlinden]

Hi...need a little help.

I have a table with the following fields:

Vendor
SKU
Description
Part Number
Unit of Measure
Buy Pack

I am trying to create a report that would allow me to select the Vendor from
a combo box then filter the records to only print the sku, descriptions, part
numbers, etc. for that vendor.

I've tried running a query, but I can't seem to get it right. Any help you
could provide would be greatly appreciated.

one of the arguments when you open a report is the filter/where
clause.

Just pass a valid where clause, and you're off to the races.
cQUOTE= " ' "

strFilter = "[Vendor]=" & cQUOTE & me.cboVendor & cQUOTE
DoCmd.OpenReport "MyReport", strFilter