Hi,

Does anyone know how to get vb to look at an array of numbers, and then generate the next number that is not shown in an access database

For instance,

1
2
3
5
6
7

Vb will look at this in an access database and will generate the number 4. If then it does it again, it will find no gaps and so create a new number 8.

I really need help with this. PLEASE HELP ME.

I will be very greatfull