Multiple Relationship Subform

[Sandpiper]

Hi. can anyone help me. I've spent the last two hours getting no where.

I have a tbl_Enquiry,tbl_EnquiryType and tbl_Questions
On the main form (frm_Enquiry), depending on which enquiry type is chosen, will depend on which questions are displayed.
this is a many to many relationship so I have a junction table, called tbl_TypeQuestionJunction.

The questions are displayed in a sub from when the enquiry type is selected, and this all works fine.

However, I then need to add a field where the user can write thier answers to the questions.
for this I have a table tbl_QAJunction with the fields
EnquiryID
QuestionID and
Answer

How can I get my subform to display the correct questions when the enquiry type is selected, with an answer box next to it and then pick up the EnquiryID, QuestionID and the answer and add them to the tbl_QAJunction.
I just can't get a query to work.

I hope this makes sense

This has really bugged me and is stopping me completing my database.
Am i going abotu this all wrong? If anyone can help, I'd be grateful
I've attached a cut down version of the DB so you can see what i'm on about

Thanks

 

[Sandpiper]

Sorry Still No Response,
If you have time to look at this and tell me if it is possible, i'd be sooooooo grateful

Thanks
A very desparate
Jo

 

[Sandpiper]

Sorry, i've still had no response. Any help and I would be soooo grateful.
A very desparate
Jo

Thanks for the response again. Unfortunately it hasn't worked.

I have re-attached the full database as it stands at the moment. it is still very much work in progress as i've been stuck on this bit for a week now and everything else has gone out of the Window

The main form to look at is frm_Enquiry
I hope you will be able to see what I'm trying to acheive.
When the Quote Type is selected from the drop down list, a list of questions with a box for the answer is displayed.
As each answer will be different for each enquiry, I have a junction table that stores the EnquiryID, QuestionID and the Answer, but I just can't get it to work.
Following your first piece of advice, I have managed to get the answer box to display, but nothing else.

Sorry if I am being really stupid, or maybe trying to make it too complicated.

Again, any advise would be greatly apprecited (on this and the database as a whole). It is really getting me down now.

Thanks very much