Combo Box Problem

[Emma35]

Hi All,


I'm conducting a survey using Access to record the opinions of the staff here on site. There are 10 questions which allow the user to select an answer to each using a combo box (which has 4 choices). For some odd reason, when i make a selection using the combo box but then decide to change my mind, the combo box won't let me change my answer. it just stays at the original value

I'd be grateful for any assistance
Thanks
Em

[CJ_London]

That is a bit like saying 'I've got a red car, it has four wheels but it won't start - why?' we would need to know about your form design, form recordsource SQL and any form code/macros to provide any targeted assistance. Suggest you look at these three things to find the problem

[Emma35]

Ok my apologies...be better if i just upload it. The form i'm having difficulty with is FrmQuestions

Thanks

[CJ_London]

it is because your rowsource is incorrect. You have

0;"10 Kph";0;"20 Kph";5;"15 Kph";0;"30 Kph"

so all but option '15 kph' are 0 and access will take the first occurrence of 0. - if you select 15 kph, the value changes

I don't know if there is any significance in the numbers (some weighting perhaps?) but

0;"10 Kph";1;"20 Kph";5;"15 Kph";3;"30 Kph"

will work

[Emma35]

Thanks for your help....it's because three answers are wrong and only one is right. Five points for a correct answer and none for an incorrect one. Is there any way around this ?

[CJ_London]

suggest use

-1;"10 Kph";-2;"20 Kph";5;"15 Kph";-3;"30 Kph"

and in your calcs use iif(answer<0,0,answer)

[Emma35]

Ok will do....thanks again