Go to a specific record in a filtered form

[AdamAA]

Hi guys. I filter a continuous form using several criteria that form a string called strWhere.

Then there is an On Click bit of code for First Name so when you click on First Name in the filtered form it opens a second form that allows you to enter more detailed information. Here is the code:

DoCmd.OpenForm "FurtherDetail", acNormal, , "[ID] = " & Me!ID

The problem is, when you click on First Name it only ever opens that record on its own and doesn't include all other results from the filtered continuous form form.

Is there any way to open a second form, pull through the filter from the first form, but go to the specific ID of the record you clicked on?

 

[jdraw]

You are asking to open the form at a specific record. Access is doing what you have asked.

If you have a mainform, and details of a mainform record on a subform-- that is a 1 to many relationship - you should investigate the Form/subForm set up in access.
It is quite automatic if your tables and field names are well structured.

see https://www.youtube.com/watch?v=YZKN_-P6wck