Double Click Event & Navigation Sub Forms

[S1LV3RF0X87]

Hello All,

I am at a loss on this one and i just need someone to point me in the right direction and i apologise if there is a thread for this somewhere I'm just not sure of the right function i should be looking for to do what i want.

I have a Navigation Form which has several tabs which have their own sub forms within each of the tabs. In one of these tabs the sub form is being displayed in datasheet format.

What i want to do is when the user uses the double click event within the datasheet sub form that the event navigates to another navigation form tab then using the sub form of that navigation form use the find record to load the record based on the ID record of the datasheet sub form that was clicked.

Hopefully that makes sense.

Thanks in advance.

 

[Saphirah]

If you want to have multiple subforms loaded at the same time i would suggest using a tab control. The behaviour is similar to a navigation control, but you can have multiple subforms loaded at the same time.

You can then just use the click event, and influence the other subform by

Parent.Form.SubformControlNameHere.Form.Filter = ...

 

[arnelgp]

here is a sample.
double click on ID or First name or Last Name.

 

[S1LV3RF0X87]

Thank you for the reply, i figured i would need to do something like that

here is a sample.
double click on ID or First name or Last Name.

Thank you for this i believe this is something that i am looking for. I will study this now and try and get it working in my scenario.

Many Thanks