Question Dmax+1 error "invalid use of null"

[PhoenixCouriers]

Hi all,

i keep getting error with this

button on click

me.invoicenumber = dmax (invoicenumber,invoicedetails) +1

any body help

 

[John Big Booty]

I think your Dmax() should look like;

me.invoicenumber = dmax ("invoicenumber", "YourInvoiceTableName") +1

My bad got that back to front

 

[stopher]

Try:

me.invoicenumber = dmax ("invoicenumber","invoicedetails") +1

 

[PhoenixCouriers]

thanks guys

 

[vbaInet]

I thought this was pointed out to you yesterday in a thread of yours?

 

[vbaInet]

By the way, the "invalid use of null" error can be fixed using Nz()

me.invoicenumber = nz(dmax("invoicenumber", "invoicedetails"), 0) +1

Show in this thread (i.e. post #11):

http://www.access-programmers.co.uk/forums/showthread.php?t=206063

 

[PhoenixCouriers]

I thought this was pointed out to you yesterday in a thread of yours?

hi there, yes many thanks

this is a different form but all it was is that i forgot to add quote marks

should have just looked at your post from yesterday

many thanks

simon