Form to Filter a Report

  • Thread starter Thread starter JulieDawn
  • Start date Start date
J

JulieDawn

Hi,

I have created a Report, called Inventory Report by Brand, that is
based on a query, called InventoryReportQry. I have also created a
form, called BrandDialog, with a combo box, which is called "Brand",
where you can select a brand name. The form also has two command
buttons, one to cancel and one to open the report. I would like the
"Open" Button to open the report so that only information related to
the selected Brand Name appears. I have looked through the forum and
tried making the criteria in the query, under the Brands field, to be
=forms![BrandDialog]![Brand], but this still doesn not work. Could
someone please help me out?

Thank you in advance. Julie
 
Since this is a combo box, I'm guessing it probably has more than one
column. The Bound Column is the one that gives the combo box its value and
may not be (in fact, probably isn't) the column you actually see when you
make a selection. The field you filter has to be based on this bound column.
 
Back
Top