Increment Numbers increasing 2 at a time

[Bob]

=Nz(DMax("CheckNumber","tblCheck"),0)+1

I have this in My Default Value on CheckNumber which is a Number field
but my records are increasing like this 1,1,2,2,3,3,4,4,5,5, Double at a
time in CheckNumber
The only thing I can think of is that I have a Combobox on top of my list
box which have the same Control Source
That eneter the check details to who they are written too?
Thanks for any help...........Bob

 

[Bill Mosca, MS Access MVP]

Bob

Most likely, your assumption that the problem is having 2 controls with the
same field as the control source is correct.

Why do you use 2 different controls?

 

[Bob]

Thanks Bill its a Query that my Combo Box dropdown list, that stops having
duplicate names if I write a check to Main Power Company I will get 12 every
year in my drop down list so I have unique Records
thanks Bob

 

[Bob]

Actually I deleted the Combobox Query and change my list box to a dropdown
list box and I am still get double numbers appearing
thanks Bob

 

[Bill Mosca, MS Access MVP]

Bob

Are there actully duplicates in the table or jus tin the query?

 

[Bob]

Bill, the Query was just on what was in the name of the check
I have given up on Sequential Numbers I am rezined to the fact you cant have
them and start them at any number you want to start with
Regards Bob
Ps they where doubling in my Table