combobox value

[raymond.tackett]

Hi there,

I'm a beginner and wanted a combo box to put the values in a box.

LIST values are: YES, NO, NA



The issue I am having is there are 18 questions 2 have 10 points and the rest have 5 points. I'd like to use a combo box and depending on the selection have that value placed in a box on the form. I don't know if I'd set this up in a table? Are there any database examples I can review?

Thank you all so much!

[NTC]

You would have a field in your table - let's call it 'ValueX' to hold the number

In the AfterUpdate Event of the combobox you place code to write the number value into the field ValueX.

What the actual value should be i.e. 5 or 10 must depend on some other value in that same record - so that your AfterUpdate code is an If/then statement.

[Bulzie]

Need more details on what you are trying to do but you can add points based on the question and the value of the combo box. In the AfterUpdate of the combo box, you could do something like:

If Me.Combobox = "YES" then

If Me.QuestionID = 1 Or Me.QuestionID = 2 then

Me.QuestionPoints = 18

Else

Me.QuestionPoints = 5

End If

Else

Me.QuestionPoints = 0

End If

This assumes you have a table of questions (QuestionID, QuestionText, QuestionPoints) and assumes questions 1 and 2 get the 18 points if Yes is marked.

[raymond.tackett]

awesome this worked thank you!!!!