I have a numbering issue. I have a series of 6 questions that are answered on individual forms. I designed the 6 questions in a single table. When the user answers question 1 the auto number is 1, question 2 the auto number is 2, so on and so forth.
How can I make it that all the questions carry the same ID number so that they refer to the same record?
I do not really understand the question - but what I think you are saying is that you have a table with 6 fields for the questions. If that Is the case have one field and the user choose from a combobox what the answer is. The datasource for the combobox is the field for the numbered answer.
The table structure is only 1 table with 6 question fields, Number field and emp field. However, because these are lenghtly questions I felt that it would be easier to answer the questions on individual forms rather than 1 form w/ subforms or tabs.
The problem that I am having is that once the first question is answered a number is generated. The 2nd question is answered another number is generated. I want to keep each question related to the same number.
Do you mean you want to have six forms update the same record? You can look into "OpenArgs" to open all five forms beyond your initial form to the same record. In that way, you will update the same record for each form. Is this what you mean?
I did take into account about the 6 question ranking thing. I suggested a table for these and a combobox with its rowsource to this table to select thed ranking - with that they can always add to the table.
Right now, the questions are 6 but it may be 10 or 11, eventually. It is for an employee evaluation form. The reason why I am approaching this with seperate forms is because the answers are maybe long and when the user clicks on the next button it will activate another question and will force them to answer.
If there will be a varying number of questions, you might want to reconsider your table design. For a bespoke project of this size, you may be ok, but generally speaking one would strive for a normalized database structure.