Requery a Subform

[Donalbain]

I have a main form (form1) that simply contains a combobox that allows
the user to select a criteria for a query.
The query controls the output of another form (Form2), and I have set
the afterupdate control of the combox box on form1 to requery form2.
This works wonderfully, and everything is hunky dory.

EXCEPT, when I put form2 as a subform on form1 the whole thing falls
apart, and while the subform is requerying, unless the criteria from
the combobox is a certain value, it always shows blank.

So, to summarise, as two seperate forms, all is well. When I use it as
a subform, form2 is rubbish..

Anyone got any ideas why this might be?

 

[Roger Carlson]

On my website (www.rogersaccesslibrary.com), there is a small Access
database sample called: "SubformReference.mdb" which illustrates how to
reference a number of things with subforms and sub-subforms.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L