code for combo box

  • Thread starter Thread starter Arain
  • Start date Start date
A

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
 
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.
 
Back
Top