I have a form which contains two sub forms. In the first subform I have 4 fields of Cut#, Size, Quantity and Style. Once the cut# is selected, a vba code runs and fill in the rest of fields.
In second sub form I have a field of Fabric# (Combo Box) which should be restricted to the “Style” value on the first sub form. I have a query which contains the Fabric# and Corresponding style and I try to write a vba code to requery once “Style value” changes. I would be thankful if someone could help me with the code.
Thanks In advance
In second sub form I have a field of Fabric# (Combo Box) which should be restricted to the “Style” value on the first sub form. I have a query which contains the Fabric# and Corresponding style and I try to write a vba code to requery once “Style value” changes. I would be thankful if someone could help me with the code.
Thanks In advance