Simple Question re: requery

[Debased]

I have a command button on a main form that runs an append query that populates a subform. When I click the command button the form remains blank and I know it needs to be requeried however can't find where to put the requery code. I added "SendKeys "{F9}", True" to the command button procedure right after it runs the append query and that does work, however I have read here many times that using SendKeys should be avoided.

Question: What is the proper syntax ie, Docmd.requery or something else
and, where does the code go?? in the command button procedure or somewhere else?

By the way, using Me.Requery did do the trick but it also caused the main form to revert back to the first record which is not what I want.

Thanks again to all of you for all your help!

 

[Rich]

YourSubform.Requery

 

[Debased]

Thanks Rich> I tried Forms!frmSanswers.Requery but I get an error msg that states "Microsft Access can't find the form referred to...."

ideas?

 

[Debased]

Got it...Me.frmsSanswer.requery....thanks again!