VB6 Code with a data base problem

I have written code for a simple form to write to and collect data from. The problem is that I want the code to look up the last number in the data base, add one to it and display the next number on my form?
The data base is written in Access.
I apprecaite the help.
Thanks
Andrew