<div>
Thanks. &nbsp; It actually had to be:<br />
<br />
me.Parent.subformcontrolna<wbr />me.form.re<wbr />query to get it to work.
</div>


Thanks.   It actually had to be:

me.Parent.subformcontrolname.form.requery to get it to work.

<div>
<div class="content wysiwyg-content">
I have an Access form with a subform on it whose records source is a table. &nbsp;The table's contents get displayed in the subform.<br />
<br />
I have a query that updates the table displayed in the subform. Actually what the query does is &nbsp;adds records to or appends the table.<br />
<br />
The query gets invoked by clicking a command button.<br />
<br />
After I run the query, how do I get the updated table to display in the subform?<br />
<br />
I think it's something like Docmd.Requery but if that's what it is, where do I put it? Or if it's something else entirely, please let me know. <br />
<br />
Thanks
</div>
</div>


I have an Access form with a subform on it whose records source is a table.  The table's contents get displayed in the subform.

I have a query that updates the table displayed in the subform. Actually what the query does is  adds records to or appends the table.

The query gets invoked by clicking a command button.

After I run the query, how do I get the updated table to display in the subform?

I think it's something like Docmd.Requery but if that's what it is, where do I put it? Or if it's something else entirely, please let me know. 

Thanks

Display updated table through 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.