OK - I had a database that was working pretty well on Friday. I opened it up to test something today and all of a sudden my form stopped working.
It is a simple form - see attached photo for the form view. When I click on either button I get the error in the attached JPG. Here is the code for the buttons:
The intent is simply to exit and close the form for the Exit button and for the Accept button to set two fields (which are hidden from view) then save the record and open a new one.
Like I said, this seemed to be working fine on Friday. To my knowledge the only things I would have done after testing this form would have been to clean up some of the formatting (get rid of record selectors, etc.).
Any thoughts?
It is a simple form - see attached photo for the form view. When I click on either button I get the error in the attached JPG. Here is the code for the buttons:
Code:
Private Sub cmdCancel_Click()
Me.Undo
DoCmd.Close acForm, Me.Name
End Sub
Private Sub cmdCommit_Click()
Me.QIPDateEntered = Now()
Me.QIPPersonEntered = Me.txtPersonID
If Me.Dirty Then
Me.Dirty = False
End If
DoCmd.GoToRecord , , acNewRec
Me.QIPPartNumber.SetFocus
End SubLike I said, this seemed to be working fine on Friday. To my knowledge the only things I would have done after testing this form would have been to clean up some of the formatting (get rid of record selectors, etc.).
Any thoughts?
