Refreshing a Subform

[Guest]

In a subform I have a combo box getting it's list from another combo box in the same subform. I have been able to retreive the data for the second combo box without a problem. However, I can't refresh the information in the second combo box without closing the form. I tried using a macro set to "Requery" but it didn't work. Any way to do it without using VB?
Thanks

 

[Roger Carlson]

Why not use VB? If you haven't before, it's time to start. In an event
procedure of the AfterUpdate event of the first combo box, put something
like this:

forms!Mainform!SubformControl.form!SubformCombo.Requery

Where you replace the actual name of your main form for "MainForm", the name
of the subform control for "SubformControl", and the name of the combo on
the subform for "SubformCombo".

On my website (see sig below) is a small sample database called
"SubformReference.mdb" which illustrates this and other referencing issues
with subforms.

--
--Roger Carlson
www.rogersaccesslibrary.com
Reply to: Roger dot Carlson at Spectrum-Health dot Org

In a subform I have a combo box getting it's list from another combo box

in the same subform. I have been able to retreive the data for the second
combo box without a problem. However, I can't refresh the information in
the second combo box without closing the form. I tried using a macro set to
"Requery" but it didn't work. Any way to do it without using VB?

 

[Guest]

That worked, thanks a lot. I've been working on it for weeks and it's nice to working correcting! Thanks