Rating System using Multiple Questions different values

[eswift]

I am attempting to create a database that will capture a rating for several questions. My access knowledge is limited, but currently I have it working where it will add a record to the database and rate it one question at a time. If I wish to rate a single vendor for several questions it would take a very long time. I am using combo boxes for rating OR agreement, and as soon as I change the first one they all change. Based on the question ID. How can I keep the question ID specific for the rating for each question. If that doesn't make any sense here is what I am trying to do:

Vendor _______

(QID1) Question 1 ...blah blah Rating(1-5) Agreement(Y/N)
(QID2) Question 2 ...blah blah Rating(1-5) Agreement(Y/N)
(QID3) Question 3 ...blah blah Rating(1-5) Agreement(Y/N)

Date _______

Add Record Button


Any help would be greatly apprecited.
Thanks in advance...

 

[gusbrunston]

Hi.

I didn't follow how your data is organized, but...

Seems as if you have QID1, QID2, QID3, etc., there ought to be also RATING1, RATING2, RATING3, etc. If so, and the controls are bound to the underlying fields, RATING2 and RATING3 will not accept the data entered for RATING1.

Questions  Ratings

   QID1     RAT1
   QID2     RAT2
   QID3     RAT3
   QID4     RAT4
   QID5     RAT5

Data type in the RATs is text, so that it can be 1, 2, 3, 4, 5, or Yes.

And here's a gratuitous, unsolicited bit of a comment...

Why combo boxes? Some might consider a text box more user friendly: "Enter 1,2,3,4,5 or else Y if you agree with the question: "

Or have I missed the point? Gus Brunston An old PICKer, using Access2000
padregus@attbi.com