v1ech
07-09-2010, 04:13 AM
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
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