S
Steve
I have searched the groups and unfortunately cannot
find/recognise the answer amongst the many similar posts.
I have a form, which is a multi-choice customer survey
or questionnaire. Questions are held as records in one
table, the answers in another, with a one to many link.
Completing the survey involves 2 forms, the first
collecting base customer data, which updates customer
table and loads all the questionIDs to the SurveyDetail
table (ie creates records for each of the questions, with
default answers, by using recordsets in the an
update/proceed command button).
The second form, containing question in text box and
answer in combo box (and which is the problem), then
loads.
The record source for the second form is a query which
brings together customer, question and answer info and is
intended to update AnswerID from default to selected
answerID in the SurveyDetail table.
The Answers on the second form are presented in a combo
box, Control Source being the AnswerID, the row source
being the Answer Table, bound to AnswerID col.
As you step through the records (ie questions), the combo
box needs to stay in sync with the QuestionID text box.
However, it only shows the answers for Question 1, no
matter which record/question is showing.
I presumed the combo box needed to requery in the on
click event, but can't get it to work.
I was using a requery in cboQIDanswer click event as
follows:
Me![cboQIDAnswer] = Null
Me![cboQIDAnswer].Requery
Apparently, not that simple...any assistance much
appreciated.
Thanks
Steve
find/recognise the answer amongst the many similar posts.
I have a form, which is a multi-choice customer survey
or questionnaire. Questions are held as records in one
table, the answers in another, with a one to many link.
Completing the survey involves 2 forms, the first
collecting base customer data, which updates customer
table and loads all the questionIDs to the SurveyDetail
table (ie creates records for each of the questions, with
default answers, by using recordsets in the an
update/proceed command button).
The second form, containing question in text box and
answer in combo box (and which is the problem), then
loads.
The record source for the second form is a query which
brings together customer, question and answer info and is
intended to update AnswerID from default to selected
answerID in the SurveyDetail table.
The Answers on the second form are presented in a combo
box, Control Source being the AnswerID, the row source
being the Answer Table, bound to AnswerID col.
As you step through the records (ie questions), the combo
box needs to stay in sync with the QuestionID text box.
However, it only shows the answers for Question 1, no
matter which record/question is showing.
I presumed the combo box needed to requery in the on
click event, but can't get it to work.
I was using a requery in cboQIDanswer click event as
follows:
Me![cboQIDAnswer] = Null
Me![cboQIDAnswer].Requery
Apparently, not that simple...any assistance much
appreciated.
Thanks
Steve