I have a database to keep track of electronic component specifications.
All parts have a "parttype"field and all part types have separate "specification" table
Eg Part type "Resistor" is linked to "Resistor_spec"
Is there any way I can use a tab control with the main part details on page one and the corresponding specification subforms on the preceding pages. When I browse records on the main form is it possible to have the non corresponding specification pages hidden, just leaving the one corresponding to the part type shown on page one
I.e. If parttype = resistor, then show resistor spec, hide all the others?
Any help would be very much appreciated.
All parts have a "parttype"field and all part types have separate "specification" table
Eg Part type "Resistor" is linked to "Resistor_spec"
Is there any way I can use a tab control with the main part details on page one and the corresponding specification subforms on the preceding pages. When I browse records on the main form is it possible to have the non corresponding specification pages hidden, just leaving the one corresponding to the part type shown on page one
I.e. If parttype = resistor, then show resistor spec, hide all the others?
Any help would be very much appreciated.
