Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

GoTo Next Blank Record 1

Status
Not open for further replies.

infinitx

Technical User
Joined
Feb 26, 2004
Messages
212
Location
US
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?
 
Thankd for the information ESquared!
 
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:

Code:
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!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top