Dup ID numbers being generated

[DMBLuva]

Good Morning,

I created a database about a year ago that generates ID numbers that are unique and have the string "PD-" in front. Here is my coding:

Private Sub CreateNewIssue_Click()
Dim JobIDprefix As String
JobIDprefix = "PD-"

DoCmd.ShowAllRecords 'in case it's filtered
DoCmd.RunCommand acCmdRecordsGoToNew
Me.txtJobID.Value = JobIDprefix & DMax("id", "jobs")

It has worked PERFECTLY except within the last 3 weeks. I have done nothing to this coding to explain why all of a sudden it is creating duplicate numbers. It's having issues right at the runcommand.

Now, we did upgrade a couple months ago from 2003 version to 2007. I wasn't sure if this is what has caused the issue.

Anyone able to help? THANKS IN ADVANCE!!!

 

[SkipVought]

Hi,

Your MS Access questions will be much better addressed in one of the many MS Access forums like Forum701.

Skip,
[sup]Don't let the Diatribe...
talk you to death![/sup][sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[DMBLuva]

Thanks! I wasn't sure where to post it. I will move it there.