Re: refreshing combo box on subform
- From: "Ken Snell \(MVP\)" <kthsneisllis9@xxxxxxxxxxxxxxxxxx>
- Date: Wed, 18 Apr 2007 13:52:33 -0400
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
.
- Prev by Date: Re: Set record from subform to current record in Mainform
- Next by Date: Re: How Do I make fields not appear on a form or report
- Previous by thread: Re: Filter a form from a table
- Next by thread: Re: Incremented Value for Subform Line Number (?)
- Index(es):