Open a Form using a Macro

[chrisd49]

Hi All
Can someone help me with opening a form from another form using the OnDblClick event and to open the form using the data in the record to open it at the same record. ie Site Name = CP House so the form opens with CP House data showing, Site Name = St James so the form opens with St James data showing etc.
Thanks
ChrisD

 

[Jonathan Kok]

If you can only access the second form from the first form, set the form source query to select only the Site Name of the first form, ie,
=Forms!firstform!SiteName