Hello guys!

I m struggling with a small problem and i hope you guys can help me.

I m using Access2k7 and i have built up a small tool with a form based on a table to work with the records in the table.

In my Form i have a List displaying all the records in my table.
What i m now trying to do is marking a record in my List, click a Button and get the Number of this record.

The plan is to open another form for editing the record, and i need the number to navigate to the marked record in the new form.

I do have an ID Autovalue but this is not equal to the number of the record since sometimes i have to delete a record and the ID just remains the same with the deleted one missing.

I would like to solve this with VBA so i d be happy if you guys knew help!

Thanks in advance!

Regards,

Oliver