Refresh Main Form after Subform Click
Posted on 2006-10-31
hey guys, I have two forms... one main form and one subform. I have the following code:
If MsgBox("Are you sure this information is accurate? You cannot edit changes once they are submitted to the Control Sheet.", vbOKCancel) = vbOK Then
DoCmd.GoToRecord , , acNext
For some reason, this refreshes the main form just fine, but instead of making the subform go to a new record (as I wanted with DoCmd) it sends it to the first record. Is there something I can add to make the subform go to a new record as well?