Is there a way?

[HowardChr]

This may be a bit detailed, so stick with me. Is there a way to have a form which you can pull tabel information into, but look at a specific line? I am trying to create a database that will pull up the first line of a specific tabel's information, then when a command button is pressed, it will pull up a seperate form with the information from line 2 of that SAME tabel. I don't want this to be done by clicking the arrows at the bottom of the form. I actually want this to populate seperately.

Lets say I have a Loc_ID box that is pulling the Loc_ID from a tabel.

Any information anyone might have will be MOST helpfull!

 

[KeithG]

Sure you could do that. How are you going to determine which row is actually the first row in the Table? For instance if you had the table sorted Ascending the smallest value of that field would be first. But it you had the field sorted descending the largest value would be first. the point I am trying to make is that the first row will not always be the same record.

 

[HowardChr]

Sure you could do that. How are you going to determine which row is actually the first row in the Table? For instance if you had the table sorted Ascending the smallest value of that field would be first. But it you had the field sorted descending the largest value would be first. the point I am trying to make is that the first row will not always be the same record.

The tabel I am trying to pull from has an autonumber format and is sorted in that manor from a-z. Is there a certain type of logic that I should use however? As of now, each time I have a form come up, it starts at the first record, which is not what I want it to do. I want it to come up with the first record, then click a few buttons, then the next time a new form comes up with the same info on it, I want it to show the second record's information.

 

[HowardChr]

Frustration!

Working on the same issue now for over 2 hours lol... Everything I have tried has failed terribly. I know I'm a noob, but any ideas?