S
Stephen Glynn
I've got a lengthy table of food products which fall into various
categories and I've got a form in which the operator selects the
appropriate category from a combo-box so as to display only Dairy
Products or Breads or whatever in the subform.
My table also includes a number of yes/no fields for things like
'vegetarian' or 'low-fat' or 'on offer' (and, of course, a product can
be both vegetarian and on offer simultaneously).
If I put a series of check boxes for each of these attributes on the
main form, how do I get the subform to display all products in the
category if none of the boxes are checked and, if one or more boxes are
checked, only to display products within the category that have the
desired attributes?
Steve
categories and I've got a form in which the operator selects the
appropriate category from a combo-box so as to display only Dairy
Products or Breads or whatever in the subform.
My table also includes a number of yes/no fields for things like
'vegetarian' or 'low-fat' or 'on offer' (and, of course, a product can
be both vegetarian and on offer simultaneously).
If I put a series of check boxes for each of these attributes on the
main form, how do I get the subform to display all products in the
category if none of the boxes are checked and, if one or more boxes are
checked, only to display products within the category that have the
desired attributes?
Steve