Microsoft, Access, 2007, VBA - record entry form still adds record when canceled

This is driving me bonkers!  I have an Access 2007 database to track engineering requests.  I've completed 3 sections and now the 4th section (other than storing different information, they all function the same) keeps adding extra records even when the entry request is canceled.  When the form opens with blank fields to enter, if I click the Cancel button, the add request cancels fine.  But when the Requestor field is entered, which calculates a request number, then I click Cancel, an empty record is still added with just the request number and requestor info.  The code is EXACTLY the same as 2 other sections of my database and they both work fine.  Did I just get lucky with the other 2 sections?  Please help.

Thanks!
Helen

Here's the code behind the Requestor combo box in the form...
Private Sub Requestor_AfterUpdate()
  Dim tempNo As Integer
  Dim rs As ADODB.Recordset
   
  Set rs = New ADODB.Recordset
   
  tempNo = 1001 + DCount("*", "FiberSimTable")
  Me!FiberSimNum = "FS-" & LTrim(Str(tempNo))
End Sub

Here's the code behind the Cancel button on the form....
Private Sub Cancel_Click()
  Dim intAnswer As Integer

    intAnswer = MsgBox("Are you sure you want to cancel this request?", vbYesNo + vbDefaultButton2)
  If intAnswer = vbYes Then
    DoCmd.Close acForm, "FiberSimEntry"
    DoCmd.OpenForm "FiberSimMenu", acNormal, "", "", acEdit, acNormal
  End If
End Sub
Start Free Trial