code for combo box

[Arain]

I have this combo box which has classid from the classid table. And then I
have a subform with classid, menu and module. I want the subform to change
based on the selection of the combo box. I have tried requery, refresh etc.
can someone tell me what and where to write the code for the combo box to
change the subform.

Thanks

 

[ldiaz]

In the query connected to your form, and on the field that you want to use
as reference add this code:

Like Nz([Forms]![yourformname]![yourcomboboxname],"*")

then in your combobox after Update event you need to make a subform requery.

I hope this help.