On Tue, 16 Jun 2009 16:47:01 -0700, cjgav
wrote:

Hi Steve
I've set this up as far as I can see how you have advised.
When I update the date no number is generated in the table TblInovice if I
open vb the formula DMax("[InvoiceNumber]","TblInvoice") + 1
Is highlighted in red when I run compile I get a syntax error can you help?

Please copy and paste (don't retype) the entire VBA procedure to a message
here.
--

John W. Vinson [MVP]