Open Relevant Form Based on 2 Combo Boxes?

[phn]

Hey guys, I'm not sure if this is possible, and it is the most challenging thing that I have tried to implement into my database to date.

What I have is a booking form which allows you to Add Bookings for camera kits.

When a customer comes in and would like to book a kit, the form must be filled in with the relevant details, I have 2 combo boxes on this form.

The first is the Kit selection, there are 5 camera kits.
The second is an option to book the full kit out, or just components.

So here's the tricky part...

When the first combo box selection is made (eg. Kit 3) I need the Kit3 table to be active.

Then, when the user selects "Components" from the second combo box, I need a form to open up based on both of the above.

So a form based on tblKit3 would be opened and the user can manually select the components that they require to be booked out.

Any help at all would be appreciated.

 

[neileg]

I am worried that you have a table for a single kit. You sould have one table for all components whether theyform part of a kit or not and another table that matches kit numbers to these components.