I am trying to create a subform on an unbound form in VBA. I want to write codes to be able to control the disply of my subform by say a textbox. This is how I want it to work.
The record that is feeding/supporting the subform has a FirmID Field that associate it with a particular firm. As the FirmID changes I want the produt/brands that is associated with that particular firm to display in the subform. Remember the subform is supported by the brand/product table that has a firmID field.
Could someone please help on how or the best way to do this?
The record that is feeding/supporting the subform has a FirmID Field that associate it with a particular firm. As the FirmID changes I want the produt/brands that is associated with that particular firm to display in the subform. Remember the subform is supported by the brand/product table that has a firmID field.
Could someone please help on how or the best way to do this?