What about using the onclick event
then use "docmd.openform formname,,,where statement"
where the where clause opens the form for the specific record you are clicking on. For example use the primary key value of the record as a reference.
or
if you want to open/goto the form and show all...