Darcy

OK Fiely simple, to get the unique number you can use the 'ID' field to
create the unique value.  The question then becomes how do you get that value
from the access database and display it on the form.

I have one soluition i like, the user fills out the form and presses a
button, this button submits ALL the data to the database and assigns it an
'ID' number.  I then have a message box appear saying "Your reference number
is '@ID', please keep this for future use."  That way the database does the
work for me and i just show the results.

You could also have the submit to database point earlier in the form as well.

I hope this helps

Cheers Adam