Refreshing subforms code

B

Brian R

I have a Main form with SubForm1 and SubForm2, both linked
to the same table but presenting the data differently.
When I enter a new entry into the table I want the two
subForms to refresh to include that new entry. Try as I
might I have not been able to find a line of code or
command that I can attach after the append query code below
to do that.

Dim stDocName As String

stDocName = "Q_NewEntry"
DoCmd.OpenQuery stDocName, acNormal, acEdit

I would also like the two subforms to "goto" that new
entry.

Any help would be greatly appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top