You must write a record to the table to make it "stick" You can easily print
a value on a report, but it won't repeat unless it's saved. Normally, this
InvoiceNumber is created when the records are created. Take a look at the
Orders and OrderDetails tables in the Northwind Sample database to see how
is it can be achieved.

Signature
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com
>I have created a delivery table that contains all of the usual fields ,
> Pickup, Delivery, Billing, NoPeices, Weight... etc. The table is updated
[quoted text clipped - 12 lines]
>
> Randy
Randy Christiansen - 29 Dec 2007 20:51 GMT
I had forgotten about Northwind... thanks for pointing me in that direction.
> You must write a record to the table to make it "stick" You can easily print
> a value on a report, but it won't repeat unless it's saved. Normally, this
[quoted text clipped - 17 lines]
> >
> > Randy