Yes/No Query

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

Guest

I have a set of products we produce and when people enter a product change
request they check the product that the change applies to. I would like to
run a query for a report where someone can choose the product they want to
see all the product changes for. How would I do that.

Thanks,
 
well, presumably you have a table that lists all your products, with a
primary key field (which i'll refer to as ProductID), and perhaps a product
name or product code field, and maybe a description field. and then another
table that lists all change requests, with a foreign key field (which i'll
refer to as chgProdID) that links back to the primary key of the products
table.

you can create a form, with an unbound combo box. set the RowSource property
of the combo box to the products table, and make sure that the BoundColumn
property is set to 1 (that's the default value). add a command button to the
form, to open the report. create a query based on the change requests table,
and set criteria on the chgProdID field, as

Forms!FormName!ComboBoxName

build a report based on the above query. open the form, choose a product
from the combo box droplist, and click the command button to open the
report.

hth
 
Back
Top