Combo box sync

  • Thread starter Thread starter Steve
  • Start date Start date
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
 
Don't worry about this one - I have sorted it (almost I
think) using a value list row source and updating it
using an SQL query in the on current event. All thanks to
messrs Litwin, Getz and Gunderloy and their Access 2002
desktop book (page 357).

I ended up using a list box

Steve
 
This has since been fixed using an sql query in on
current event to populate value list in row source.
 
Back
Top