combo box to also change subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If I use a combo box on a main form that has a subform, how do I get the
subform information to change simultaneously with the change to the main
form's combo box?

thanks,
c
 
You want the choices available in the subform's combo to be limited,
depending on which value is chosen in the main form's combo?

Use the Current event of the main form, to build a SQL statement as a
string, and assign it to the RowSource of the subform's combo.
 
Back
Top