Opening one form and then another based on values

[prmitchell]

Hi
Whilst I know how to open a form based on the value selected from a combo box (selecting a client) on a switchboard, I then want the second form to have a combo box (based on the selected value from the combo box on the switchboard , i.e. the contacts for the client) and to then be able to open a third form to enter jobs set by the contact person (of the client).
The db structure is
1 client to many contacts
1 contacts to many jobs

thank you in anticipation

 

[John Big Booty]

You can use the OpenArgs portion of the OpenForm method to pass information between the form being opened and the calling form.

The OpenArgs can then be tested in the form that has been opened On Load event