refreshing combo box on subform

G

Guest

I have a subform with 2 combo boxes. The selection of one combo boxes limits
the selections the user can choose from in the next combo box. This is done
using an after update on the first combo box. The problem that I am having
is refreshing the 2nd combo box with based on the first combo box without the
user choosing the value in the first box. Is there a way I can call the
after update procedure from the main form?

TIA,

Kim
 
K

Ken Snell \(MVP\)

Me.NameOfSubformControl.Form.SecondComboBoxName.Requery

where NameOfSubformControl is the name of the subform control (the control
that actually holds the subform).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combo box help 1
filter query on combo box in a continuous subform 0
2nd Combo box does not change subform 4
Access Control on subform / combo box requesting parameter 0
synchronized Combo Boxes in subforms 2
Subform combo boxes 2
New records don't display on form with combo box 1
Combo Box results to Subform 1

Top