Using cmd buttons to open sub-forms

[Neil_Pattison]

I am working on a database to hold the data regarding our company vehicles. I have a table for the details of the vehicle (i.e Registration, VehicleType, Drivername etc) and a number of tables for different types of equipment (AccessEquipment, LiftingEquipment, StandardEquipment and others).

I have a form that runs on a query with the criteria to search for the registration number. I have also set up forms to show each type of equipment to use as sub-forms. I would like to have on this main form a number of command buttons that would open the specific sub-form on the main form.

How can I do this? Any ideas would be greatly appreciated?

 

[Rich]

It would be better if you normalised the structure to start with.
You probably only need one or two tables for equipment. Post some more details of your setup

 

[jrjr]

I would like to have on this main form a number of command buttons that would open the specific sub-form on the main form.

How can I do this? Any ideas would be greatly appreciated?

Set the visible property of the sub form to no. Onclick event of your button:

YourSubFormName.visible = True
or:
YourSubFormName.visible = False