<div>
Hi mikem.<br />
Try to do this in Subform1 AfterUpdate event:<br />
<br />
me!Parent!Subform2.Form.Re<wbr />quiery<br />
<br />
Regards,<br />
Dedushka
</div>


Hi mikem.
Try to do this in Subform1 AfterUpdate event:

me!Parent!Subform2.Form.Requiery

Regards,
Dedushka

<div>
Didnt quite work, however it put me on the right track and I have it working now. Thank you... If you re-submit as an answer I will give you the points.<br />
<br />
Mike
</div>


Didnt quite work, however it put me on the right track and I have it working now. Thank you... If you re-submit as an answer I will give you the points.

Mike

<div>
For info I did the folowing:<br />
<br />
DoCmd.GoToRecord , , acNewRec<br />
Forms![MainForm]![SubForm2<wbr />].Form.Req<wbr />uery<br />
<br />
I had to do this through a click_event on a button. First it updates<br />
the table with the new info and goes to a new record, then your code (slightly modified) after this event.<br />
<br />
Thanks again<br />
<br />
MIke
</div>


For info I did the folowing:

DoCmd.GoToRecord , , acNewRec
Forms![MainForm]![SubForm2].Form.Requery

I had to do this through a click_event on a button. First it updates
the table with the new info and goes to a new record, then your code (slightly modified) after this event.

Thanks again

MIke

<div>
Dedushka:<br />
<br />
Er, you forgot to mark you acceptance as an answer.
</div>


Dedushka:

Er, you forgot to mark you acceptance as an answer.

<div>
<div class="content wysiwyg-content">
I have a database with one main form and in it are two sub forms. Sub form 1 updates a separate table. Sub form 2 displays the results of a query based upon the input from subform 1. When the user adds information to the table, I need the query to re-run (or the sub-form 2 to requery) when new data is added to the table. However using Requery [code_to_subform2] nothing appears to happen. I guess I am on the wrong track here ..<br />
<br />
any help on this would be appreciated.<br />
<br />
Thanks,<br />
<br />
Mike
</div>
</div>


I have a database with one main form and in it are two sub forms. Sub form 1 updates a separate table. Sub form 2 displays the results of a query based upon the input from subform 1. When the user adds information to the table, I need the query to re-run (or the sub-form 2 to requery) when new data is added to the table. However using Requery [code_to_subform2] nothing appears to happen. I guess I am on the wrong track here ..

any help on this would be appreciated.

Thanks,

Mike

Requery a Query in a 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.