Sets of Fields on a subform

[Topham]

Hello all,

I have a subform created with a set of fields, 2 being a Drop Down, and 1 input text fields. The 2 drop down fields are used for which type of test is done (Electrical, mechanical, structural, etc) and who done the test and the input text field is for when the test expires. The data is on a database with 'Booking ref', 'Test Type 1', 'Examiner 1', 'Expiry date 1', 'Test Type 2', 'Examiner 2', 'Expiry date 2' etc

Now heres the part i can quite get around. There is a possibilty of 7 tests being done by different people, but commonly there is only 1 done. So i would only have 1 set visible for the time being and when data is inserted to this set of 2 drop downs and 1 input text field its put into the table in columns 'Booking ref', 'Test Type 1', 'Examiner 1', 'Expiry date 1'. Then make another set of 2 drop downs and 1 input text to insert into 'Test Type 2', 'Examiner 2', 'Expiry date 2' on the database, then the 3rd etc.

What would be the most efficient a simplest way?
Create all 7 sets and place sets 2-7 invisible and when data is inserted into the 1st set to show the 2nd and when theres data in the 2nd to show the 3rd?
Or is there another way?

 

[dkinley]

Yes, you could create all 7 fields and form controls. In this manner, you wouldn't need to create any fancy coding for dynamic set-up of these.

As a side note if you were to create a 'test order form', that is, someone creates the order for testing and selects which tests to perform - that data could be used to set the visibility for the testing fields.

This would ensure that all tests are conducted and the test record 'can't be closed' because the order conditions were not met.

-dK