Essentially I have a database where I have a number of check-lists that each have different responses for inspections of different pieces of equipment and instead of making different tables for different check-lists I have an tblQuestion table and a tblAnswer table. This is all very well in datasheet view however I would like to have a different form that opens for each different equipment type and allows the user to just answer the questions for that check-list.
The difficulty that I have never encountered before and I am having trouble finding how to do is how to create a form that essentially
'can enter multiple records into a single field'
What would happen ideally is the entire system would be input via a series of forms... I have worked out how to do this all the way to the point where ideally a user chooses a certain piece of equipment which in turn opens the specific form that has the equipment check-list.
As all the answers are actually going into the same field (as different records) I need vb code that links the questionid to each different text box (on the form) and inserts it into a different record (answerid).
I hope this is not too vague and someone may understand what I am asking for
For a start though maybe just some code that allows for example 10 text boxes on a single form to populate 10 different records of the same field in the same table would be a good starting point.
Thanks