Incrementing with Dmax

[bobbster2000]

In Access for Windows XP, I have a table called "Work Order". It has a field called "Job #" in which I need a way to enable the users to enter a Suffix attacted to "Job #" in Some cases. For example, if one user gets the "Job #" 25 but there's 3 parts to it. He'll need to add a suffix so we'll have 25a, 25b, 25c, three seprate records, but related. The "Job #" needs to be Auto Generated so I'm using the Dmax function but my VB skills are very poor. I need to have "Job #" be incremented by one with using the Dmax function but I keep on getting errors. Here's the code

Private Sub Form_BeforeInsert(Cancel As Integer)

JOB # = DMax("JOB #", "Work Order&quot + 1

End Sub


It tells me that (Identifer under cursor not reckonized) and the cursor is pointing to the Private Sub section.

Can anyone please assist?