Question for all you out there. I am fairly new at VBA and user forms
and have built up a database which is input through user forms. The
one area I cannot do is I want to allocat a unique number to each
record and display this in a seperate form with a label "your ref
number is XXXX" with a label and text box and command button click to
continue. The numbers are stored in the first column of the database
and are currently already there and I need to read the one relating to
the last entry.

Any help you can give would be appreciated.