Going to a specfic record when knowing the ID column

[Ben McLaurin]

I have a form with the info like First Name, Last name and a few other
things, based off a table (TABLE B). I have a function that opens a
list where the user can choose what records (multuple record selection
is possible) to grab from (TABLE A) and dump it into (TABLE B).

All works fine. What I need to do though is in the form jump to the
first, or last (haven't decided which) that was dumped into (Table B).
I have the ID number of the record in (TABLE B) using a select
statement.

Now by using the ID column how do I have the form go to that record. I
assume snapshot or something is used. I have tried to look but I am
not sure of exactly what terms to serach for.

For those who have spotted that the 2 tables are not normalized you
would be correct. I have very specific reasons for doing it this way
otehr than the one "it works", which it does by the way. Most
importantly there are many items that can change in (TABLE A) that I
do not want changed in (TABLE B). Think of it as a snap shot of
informtain at that point. First and Last name are basicaly the only
things that are consistant. There are othe reasons but that is the
important one.

Thanks