DMax Problem

[DS]

My DMax statement is not working. It only works when I have records.
If i start fresh it refuses to give me a starting number of 1 let alone
any number, is the syntax wrong?

Forms!Sales.SalesDetails!LineID = DMax("[LineID]", "SalesDetails") + 1

Thanks
DS

 

[Dirk Goldgar]

My DMax statement is not working. It only works when I have records.
If i start fresh it refuses to give me a starting number of 1 let
alone any number, is the syntax wrong?

Forms!Sales.SalesDetails!LineID = DMax("[LineID]", "SalesDetails") + 1

Thanks
DS

If there aren't currently any records, then the maximum value from them
is going to be Null -- unknown or meaningless. Use the Nz() function to
convert that Null to zero:

Forms!Sales.SalesDetails!LineID = _
Nz(DMax("[LineID]", "SalesDetails"), 0) + 1

 

[Van T. Dinh]

DMax returns Null if you start fresh.

Try:

Forms!Sales.SalesDetails!LineID = Nz(DMax("[LineID]", "SalesDetails"), 0) +
1

 

[DS]

My DMax statement is not working. It only works when I have records.
If i start fresh it refuses to give me a starting number of 1 let
alone any number, is the syntax wrong?

Forms!Sales.SalesDetails!LineID = DMax("[LineID]", "SalesDetails") + 1

Thanks
DS

If there aren't currently any records, then the maximum value from them
is going to be Null -- unknown or meaningless. Use the Nz() function to
convert that Null to zero:

Forms!Sales.SalesDetails!LineID = _
Nz(DMax("[LineID]", "SalesDetails"), 0) + 1

Thanks everyone. It worked like a charm!
DS