Hi
I have a database which is a record of quotes sent.
I would like to display the previous quote number when I open up a new form
to enter the details of a new quote.
Or failing that can I make the Quote number into some kind of Auotnumber
function??

Regards
Dave

In the Form_BeforeUpdate event procedure, after any record
validtion code you might have, add:
    If Me.NewRecord Then
        Me.QuoteID = Nz(DMax("QuoteID", "QuoteTable"),0) + 1
    End If

If this is a multi-user environment, that's still not bulletproof.

--
Perth, Western Australia
Tips for MS Access users at:
        http://odyssey.apana.org.au/~abrowne