Double click event to filter a subform

[Rzgar]

Hi there! I am creating a simple database to manage the basic information of my patients.
My problem: double clicking an older visit should bring that visit in to the main screen. But I can't manage to do that..


The structure of the form: both the older visits list and the current visit are based on the same table and they are both a subform in the main form.
Your help is appreciated..

[ranman256]

both forms should be linked to the master key on top:

LinkMasterField: ClienId.
linkChildField: ClienId.

[Rzgar]

Thank you for the reply. I've already done that. My question however is how to filter one subform by double clicking on the date field of the the other subform.

[accesstos]

Hi Rzgar!

Give a try to this:

With [forms]![frmMain]![sfrmVisit].form
    .Filter = "VisitDate=#" & me![olderVisitDate] & "#"
    .FilterOn = True
End With

Replace the names in red with the actual names of your controls.