S
Sue R via AccessMonster.com
I have a command button in a form that auto fills in a reference number for
each new entry. It was working properly until recently but now keeps issuing
a duplicate error message - it doesn't increase the number by 1 anymore - and
since this is a database that I took over I'm not sure what may have changed.
An example of a number is 2239-06-112 ( the 06 being the year, the last 3
digits being the one that should increase.) The auto number is set to fill
in "on click" with the following code :
Private Sub cmdGrabID_Click()
Call modReferenceID.modSetReferenceID(Form_frmBirdSurveillance, "2239-" &
Format(Now, "yy") & "-0", "2239-" & Format(Now, "yy") & "-")
End Sub
Thanks for any help!
Sue
each new entry. It was working properly until recently but now keeps issuing
a duplicate error message - it doesn't increase the number by 1 anymore - and
since this is a database that I took over I'm not sure what may have changed.
An example of a number is 2239-06-112 ( the 06 being the year, the last 3
digits being the one that should increase.) The auto number is set to fill
in "on click" with the following code :
Private Sub cmdGrabID_Click()
Call modReferenceID.modSetReferenceID(Form_frmBirdSurveillance, "2239-" &
Format(Now, "yy") & "-0", "2239-" & Format(Now, "yy") & "-")
End Sub
Thanks for any help!
Sue