linking combobox to subform.

[rich_bell20]

Hi does anyone know how to display a subform based on a value selected in a combobox. I can get values to display in a combobox based on a combobox value selection but not in a subform. my combobox is called categories, and my subform products. Any help much appreciated, thanks.

 

[smallh]

These are the following steps you need to take:

1. Create a hidden field thats going to contain the value you selected in the combobox

2. In the onUpdate event of the combobox write the vba code to update the field you created in step 1.

3. You then need to manually link the field created in step 1 with the appropriate field in your subform.

This should work