Populate subform with blank records

[Mi]

Not sure how to search for a solution to this problem so here goes.

Table customers - names, city, etc
Table questions - currently 37 questions needing a yes/no answer

I would like to create a form/subform that pulls up the customer and then shows ALL the questions with a drop down y/n answer for each question. I am only able to get it to show one question at a time in the subform. I am stumped on where to begin.

Thanks for your assistance

Mi

 

[Joe4]

Sounds like you may have your subform set up to just show a single record.

Go into the Properties of your Subform, and try changing the Default View setting to "Continuous Form" (it is probably on "Single Form").

 

[Mi]

no, it is on Continuous Forms. Even in datasheet view and it still only shows those questions that have been answered.

I might have to figure it another way.

I did not want to have to create unbound questions and then transfer the "results" to the actual questions since I am not sure how many questions there could end up being.

 

[boblarson]

Looks to me that you are missing a junction table:

CustomerID
QuestionID
QuestionAnswer


and then you would need to do an append query to append all questions to the table for a customer.

 

[Mi]

Aha. Append Query. I think that is the missing element. I will need to look into how to do that.

 

[Mi]

Well, I looked into it and was defeated on how to make the form and subform to work.

I have the junction table with:
CustomerID (from tblCust)
QuestionID (from tblElement)
QuestionAnswer -Y/N combo box

I did create an append query and it will add the questions to the table.

Main form shows the CustomerID, subform is linked to the Main form by that ID.

Can I get a little more help please. I have not had to make a form work like this before.

Thanks again,
Mi