Options not being held in combo box

[jojo86]

Hi

I have this form that users need to answer questions that will show up scores. I have created the form, which works well, except for the fact that when a user choose an answer, it is not 'sticking'.

For example, for the first question, a user will pick one of the answers, then move on to the next question and answer that. However, when the user then goes back to the questions previous to those they have answered, the answer has defaulted back to on of the choices from the combo box.

I cannot see why this is happening but if anyone can help me today, I would be very grateful. I have a tight deadline with this and its drivingme nuts!

The attached DB file is the form in question. Thanks

 

[MStef]

Here it is.
I made a change in the tbl "Response" (added a field "Score"), in "qryResponse" (the same), in frmResponse (the field Score (Text6), I linked on qry field Score). I made a change in VBA. I reduced tbl Response on 28 records. I put Relationships.
I think it is what you need.

 

[jojo86]

Thanks for that, I am glad it works. However, I have tried to put them in to the full versioned database which has over 450 records, which equates to over 6000 questions (having 13 questions for each record) and that means there are over 15000 answers (having 33 answers for each record [at least two for each question]).

I have done all the things you have done, but unfortunately, when I try and choose an answer from the combo box, it is the same answers for each question. The one you sent across is not, and this doesn't make sense!!!

Hope you can help

 

[jojo86]

Actually, I forgot to include one piece of code that you added, and now it works!

Thank you so much for your help, it is much appreciated