<div>
Hi mamadouthiam,<br />
I would guess that the code you neeed is:<br />
<br />
me.subreportcontrolname.Fo<wbr />rm.requery<wbr /><br />
<br />
in the afterupdate event procedure of the combobox.<br />
<br />
Pete
</div>


Hi mamadouthiam,
I would guess that the code you neeed is:

me.subreportcontrolname.Form.requery

in the afterupdate event procedure of the combobox.

Pete

<div>
yes, that works OK - Ive just tested it here.<br />
<br />
<br />
Pete
</div>


yes, that works OK - Ive just tested it here.


Pete

<div>
Pete,<br />
<br />
I tried but I got the error that the database can't find a macro entitled me.subreportcontrolname.Fo<wbr />rm.requery<wbr />. &nbsp;Any idea why it thinks the &quot;me&quot; is referencing a macro?<br />
<br />
mamadouthiam
</div>


Pete,

I tried but I got the error that the database can't find a macro entitled me.subreportcontrolname.Form.requery.  Any idea why it thinks the "me" is referencing a macro?

mamadouthiam

<div>
Pete, &nbsp;<br />
<br />
You got it.<br />
<br />
I put the code in the expression builder not in the VBA. OOops.<br />
<br />
Many thanks
</div>


Pete,  

You got it.

I put the code in the expression builder not in the VBA. OOops.

Many thanks

<div>
<div class="content wysiwyg-content">
I have a subform (one of several on a larger form) that is not linked to the form. &nbsp;It is just sitting there displaying information.<br />
<br />
On the form itself, there is a combo box which (upon picking a value) provides the parameter for the query that underlies said subform. &nbsp;However, when I try to have the subform update when changes in the combo box are made- no joy. &nbsp;I tried a requery after update on the combo box but I imagine the problem to be that since there is no link between the main form and the subform that this does not occur.<br />
<br />
The question is...How can I force the requery on this unlinked subform when a change in the combobox is made?<br />
<br />
Thanks,<br />
<br />
mamadouthiam
</div>
</div>


I have a subform (one of several on a larger form) that is not linked to the form.  It is just sitting there displaying information.

On the form itself, there is a combo box which (upon picking a value) provides the parameter for the query that underlies said subform.  However, when I try to have the subform update when changes in the combo box are made- no joy.  I tried a requery after update on the combo box but I imagine the problem to be that since there is no link between the main form and the subform that this does not occur.

The question is...How can I force the requery on this unlinked subform when a change in the combobox is made?

Thanks,

mamadouthiam

Requery an unlinked subform

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.