Hello (again )
firstly thanks to all for the help am getting on here.
now to the question....
i have the following
Private Sub Toggle66_Click()
On Error GoTo Err_Toggle66_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "SIR"
DoCmd.OpenForm stDocName, , , stLinkCriteria
but i dont want the form to open if the append query has an error, any solutions to this?