Hi again all.

My database has a primary key called ID, which is an autonumber.

In VB new users are created and added to the database and automatically assigned a new number (not necessary sequential to the previous ID - but higher).

As soon as the new entry is created, is there a way I can instantly determine the new ID number?

I thought about looping through the database and looking at each ID number & comparing them, and the highest number will be the new ID, but I dont know how to do this in VB.

The database is access, and I'm using ado.....can anyone help me here.

I hope I have explained myself well enough.