GoTo Next Blank Record 1

[infinitx]

Hi,

I have a table that has a pre-entered autonumber:

Item ID ICL 1
1
2
3
4
5
6
7
8
9
10

I have a form where you add the ICL 1 to the table under an Item ID of 1. When I close the form and I open it again, the record that I have just entered is still visible.

Is there any way to go to the next blank record which in this case would contain an Item ID of 2?

 

[infinitx]

Thankd for the information ESquared!

 

[infinitx]

I ran into a little trouble. Going back to this:

- Level 4
- Level 3
- Level 4


- Level 2


- Level 4
- Level 3
- Level 4

Level 1

- Level 4
- Level 3
- Level 4


- Level 2


- Level 4
- Level 3
- Level 4

For Level 1, there might only be one Level 2. If the user enters only one level 2 and when I use this:

IsNull([ICL 1]) or [ICL 1]=""

It messes up my whole numbering system because when I programed the tables, I programmed them with having the user enter two level 2's in mind.

Any ideas?

Thanks!