Filters in subform

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

Guest

I have a problem concerning filtering fields in subform by selecting the
criteria from another field in the subform.

The subform is based on a query build on these tables:

Products: Containing the name of product and price pr unit
Orderspecifics: Containing specific info to the order on the single product
(count
of products time for delivery etc.)
Product_Category_Link: Linking products to more than one category

PROBLEM: I would like to filter the field products by choosing a category in
the subform and by that not having a whole bunch of "not needed" products to
choose from.

Any help is higly appreciated

Regards
 
As a note to the first message. I want both the category field and the
product field in the subform to be comboboxes, so each post in the subform
shows the category and the product. This in order to show a report for each
post of the parentform with the subforms post..

"Michael Hummelshoj" skrev:
 
Back
Top