Double Click Event to Open Form showing Specific Subform

samjh

Registered User.
Local time
Today, 16:49
Joined
Jan 10, 2013
Messages
64
Hi,

Appologies agian if this has been listed before.

I have a form Client Commitments by Cost Centre, this is a form with the csot centre details on it and a sub form with the clients who have commitmetns against that csot centre (these commitments are summed to give a total by client).

I have a double click event wihtin the subform to open the Client Record if you bouble click on a specific client.

However each client record has a subform with all their commitments, and each commitment could have a different cost centre.

My query is to find out if it is possible on the double click event, to open the Client record and only show those commitments where the cost centre matched the cost centre I was viewing in the original Client Commitments by Cost Centre form. If this is possible could someone explain how I do this please.

Thank you.
 

Users who are viewing this thread

Back
Top Bottom