refreshing combo box on subform

K

K

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

Clearing combo boxes and a text box 2
Dynamic Naming of Form Button 3
Creating a Search using a combo box and then creating a report. 4
Combo box 0
Synchronize combo boxes 2
Link a text box based on drop down box with four options MS Word 365 0
Word OLE to check spelling in text box 1
Combo or list box 0

Top