Re: refreshing combo box on subform

Tech-Archive recommends: Speed Up your PC by fixing your registry



Me.NameOfSubformControl.Form.SecondComboBoxName.Requery

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

Ken Snell
<MS ACCESS MVP>



"K" <K@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:BF6F841F-8118-495C-AECC-73683BA5F6B8@xxxxxxxxxxxxxxxx
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


.