I have two forms, frmGrindScrap and frmGrindScrapConfirm. When the command button cmdUpdateLbs is clicked on frmGrindScrap the frmGrindScrapConfirm form opens.
When the user confirms the data it runs an update query to update the information for that record. After this query runs I would like to set the first form (frmGrindScrap) to a new record. so that the user does not have to click the "New Record" command button.
I figure the code would go right after the DoCmd.Close that closes the confirmation form, I just can't figure out what it should be.
Thanks for your help in advance and have a great day!
Private Sub cmdUpdateRegrind_Click()
On Error GoTo Err_cmdUpdateRegrind_Click
Dim stDocName As String
stDocName = "qryUpdateRegrindOther"
DoCmd.OpenQuery stDocName, acNormal, acEdit