Passing value in combo box, how?

[FormAcCeSs]

My goal is to achieve a "right" value, when question answered correctly.
Ex: (Form)
1. My age is?
A) 2
B) 1
C) 3
D) None of tge above
RightAnswer "B" (Combobox, where all right answered preserved)
"Choices" A or B or C or D (Combobox restore value dropdownlist)
Now, the "Wrong" can easily shown value once I enter to "Validation Text". But I got stuck in it less I ESC. Cause I dont know which of which should have relation or what default value, or validation rule to enter. My problem is function.
How can I get a Msgbox so when I come accross to the right answer (for this one is "B" I will get the result saying "Right"? so then I can move on to the next question.
Also the function plan should applied to all question even to new question added entry.
Please am willing to negotiates, cause I really wants to learn this types of data system.

Richard Carey

[NeoPa]

If you refer to the ComboBox object in VBA directly then the current value of that object is returned. This is because the default property of the object is the .Value property.

I think that answers your question, but unfortunately I can't make much sense of what you're really saying. Very good if you really are 1 yr old (Answer = B), but please explain if there's more you need.

[FormAcCeSs]

If you refer to the ComboBox object in VBA directly then the current value of that object is returned. This is because the default property of the object is the .Value property.

I think that answers your question, but unfortunately I can't make much sense of what you're really saying. Very good if you really are 1 yr old (Answer = B), but please explain if there's more you need.

Oh thats just an example of multiple choice, doesnt refer to anything. my focus is how can be the value apply to multiple choice order of question and answer.

My Question again is I have a field with all the rightanswer listed to it. I have another field that has A or B or C or D,

(FieldID)
(Field1) What is my age?
(Field2) A) 2
(Field3) B) 3
(field4) C) 1
(Field5) D) None of the above
(Field6 or Cbobox) AllAnswerListed "B" (Which is the "3")
(Field7 or Cbobox) DropdownList A, B, C, D
Example answer is B) 3
My problem is which default value I put in to which, which Validation Rule I need to enter to which, Validation Text "WrongAnswe r" into which field?
or
Which Field() I have to put in my Code Builder?
How is there sequence?
(Like)
Msgbox
Dim strName = Inputbox "RightAnswe r"
I dont know this
Because am now and right now am confused.

What I want to make sure that when I hit or click
"B" will recognized that it is the right answer,
and will response string "RightAnswe r". and if I hit "A, or C or D" it string "Wrong Answer".
And so as this applies to all questions list.

Plus am not good with code builder and dont know how can I assure I put a right entry to it, and to which?

And I open different example in VBA utube...theres no exact value the one am looking for or same situation.
theres similar, but in utube!...theres a lot of hidden preinput to a field thats not showing you. so even you follow it through it wont work as what you looking for.

I am really willin to learn if I can have someone to teach me this or training here in vegas, I will attend one, and ready to pay for it.
Cause online is a bit confussing to me, but structor is much better so he can see what I mean and I can get the answer.

Richard

[FormAcCeSs]

Or Online chat also work

[NeoPa]

Richard,

I hope you don't think I'm trying to be disrespectful when I say that I'm not surprised you're confused.

I'm struggling to work out what you mean by your question. Not because you haven't tried hard and put effort into asking it but, I suspect, because you are having difficulty understanding the basic concepts that go with working with databases.

I live near London, England, so I cannot hope to provide hands-on training for you even if I had time spare. That said, I suspect it may nevertheless be a good way forward for you if you are serious about progressing. You say you're happy to pay for it. That may be true, but you should appreciate that such such costs are generally counted in numbers of hundreds of dollars per day.

I would suggest that a better place to start (at least) might be to work through some basic tutorials. It will take much of your time, but none of your money. When you are in a better position to understand the concepts of databases then I suspect you would look at your current requirements completely differently and have a different sort of question to ask. You'll probably find then, that more people are willing and able to help you.

Microsoft Access Tutorials (Strive4Peace)

There's even an option near the bottom to contact Crystal herself, and purchase some one-on-one training, if that's still what you want.

[zmbd]

Along with NeoPa's link, may I offer: MS Access 2010 Tutorials

Both in university and on my own, I found that often having a different Instructor explain a concept would help me to understand the idea when I couldn't grasp it from the fist Instructor's explanation.

As for the question: You are trying to create a multiple choice quiz with feedback for the correct answer and perhaps scoring? However, you don't know how to determine when the user selects the correct answer for a given question? If so, then the two tutorial sites will set you on the right path towards that goal.