Go to specific record when open form

[danikuper]

Hi,

I've searched the forum but couldn't find an answer to this one...

I have a form based on a query that summarizes a table showing only ID, Name, etc... and a button to open a second form where I show the details of the selected record.

I'd like that when I click the button, the form opens and goes to the selected record (based on the record ID or other field I have in the first form) WITHOUT filtering the form.

I tried using the OpenForm method but that either opens the form to the first record or filters and shows only one record. I also tried using the GoToRecord method but couldn't find a parameter to specify which record I want besides using "record #" which doesn't help because I don't know the record number (only it's ID or other values).

Any idea how to solve this? Let me know if more explanation is needed.

Thanks in advance!

Daniel