Combo Box Value for Subform Result

[Guest]

I need help and suggestion on inventory form that require to combine 2 combo
box value that will determine the result on the subform

 

[Guest]

There are few ways to do that, I'll give you a couple of them
1. Use the Father Child properties to link the form to the subform, using
the values of the combo boxes for the father and the link fields in the sub
form as the child value
==============================
2. link the recordsource of the sub form to the two combo boxes

Select * From Inventory Where Field1= forms![MainFormName]![Combo1Name] And
Field2= Forms![MainFormName]![Combo2Name]

You need to refresh the sub form every time you change the value in the
combo, so enter the code me.SubFormName.Requery on the after update event of
each combo.
=====================

I hope that help

 

[Tom van Stiphout]

test