Display updated table through a subform

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
dbfromnewjerseyAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Dale FyeConnect With a Mentor Commented:
add a line of code after your append query is executed, something like:

me.subformControlName.Form.Requery

HTH
Dale
0
 
dbfromnewjerseyAuthor Commented:
Thanks.   It actually had to be:

me.Parent.subformcontrolname.form.requery to get it to work.
0
 
dbfromnewjerseyAuthor Commented:
.
0
 
Dale FyeCommented:
glad I could help.
0
All Courses

From novice to tech pro — start learning today.