Open form and go to specific record based on a variable

[laavista]

I have two tables and two separate forms. [ID] is the link between them. (I cannot do a subform in this case).

Form1 displays 3 records
Have control button that goes to Form2 where [id] = NumID (NumID is "long" variable)
Have control button on Form2 to go back to Form1. It needs to go to the same record it came from. I don't want use a where clause (e.g., where [id] = [id]). This works, but the form1 is now filtered. I need all records available in Form1, but I want to go to the record it was on when the button was clicked to go to form1

Example:
Form1, record1, ID=30
Form1,record2,ID = 35
Form1,record3,ID = 40

Select record3,ID=40, then click on button to go to form2 (has where clause where ID=40).
Form2 is filtered and is correct.

Click on button to go back to form1. No Filter. It goes to 1st record (record1,ID=30). I need all records displayed, but need to be on record2,ID=35.

I really need your help. I've spent hours researching and tried many things with no luck.
Thanks, in advance.

[kimmer]

If this is what you need, thank pbaldy.

http://www.baldyweb.com/Bookmark.htm

[laavista]

WOW-- this is great. This is exactly what I was looking for. I worked 3+ hours trying everything I could to no avail. I REALLY appreciate you taking the time to respond.

One more question?

How would I use a variable for the form name in the code you provided? If I can't do this, I'll use a workaround with if statements, but it would be much easier if I can just use a variable.

THANKS AGAIN.

[ardalan2002]

If this is what you need, thank pbaldy.

http://www.baldyweb.com/Bookmark.htm

THIS LINK SEEMS TO BE A DEAD LINK.
I have the same question but can not open it.

[pbaldy]

It is still a good link, at least it works for me. If you still can't get to it I'll copy the page here.