Trouble programming combo boxes

[trolleri]

Question 1:
I wish to program a combo box to have sentences as predefined answers, and then save the answers as a numeric value in the table instead of the shown sentence. E.g. a question: "What sex?", with predefined answers: "Male; Female", stored as "1" or "2" in the table. Found this (link) guide, but how do I set the combo box to store the answers in a table without a Control Source set for the combo box? I have hundreds of combo boxes spread out on different forms, all forms having its own table as the record source.


Question 2:
Some questions have been answered with different units. E.g. "How many times a day/ a week / a month / a year did this occur?”. I would like the answers to be stored in one specific unit, for easy comparison. Is it possible to make the form calculates the value, and stores it for the unit "a year"?


Question 3:
I have a yes/no question followed by a text box "if yes, then describe in text". Is it possible to grey-out the text box, if "no" is selected in the previous question?

[amrut]

Question 1: when you drag a combo box to add to your form, select the 2nd option to "Type the values I want". Set no. of columns to 2.
Type the values 1 and 2 in Col1.
Type Male and Female in Col2.
On the last page of the wizard, select your fieldname to store the value.
Set column widths to 0;3 ( Setting the first column to zero will hide it from user.) The table will now store 1 for Male and 2 for Female.
If combo box's row source is a table or query, you have to set up the "bound column" cautiously. You can always hide a column by setting the width of corresponding column to zero.
question2 : Not clear to me
Question 3 : In the afterupdate event of "yes/no" field, use the Me.yourTextBoxName.Enabled=False to grey it out. Better option is to disable the text box initially, set the default value of yes/no field to "no" and enable the text box if answer is "yes".

[trolleri]

Thank you for the answer!
The solution sounds perfect, I will work on it tonight

question2 : Not clear to me

What I meant was this: The surveys have been answered in the paper form, and now needs to get stored into records in the database. Some questions have been answered by the subjects as "I have this experience X times a week", but other subjects answered the same question with "...X times per year."

It is easy to multiply the X from the first subject into a full year, but tidy for the end-user to do this by hand for all subjects. Is it possible to make a form that can handle different units, and then calculate them into one specific unit before saving the data into the record, ensuring that the data have the same unit.

[trolleri]

Your solution for problem #1 works like a charm - thank you


I have some trouble implementing your solution for problem #3. Followed your instructions, and used the code:

Me.MyComboBoxName.Enabled=True

but I got the error cannot find the object 'Me.'

Both the combo box with the "after update"-event, and the combo box I want to enable, is located in the same subform. So I tried this:

[forms]![MySubformName]![MyComboBoxName].Enabled=True

But again I got the error cannot find the object 'forms!MySubformName!MyComboBoxName.'

The subform is put inside a tabbed control on the main form, so I finally tried this:

[forms]![MyFormName]![MySubformName]![MyComboBoxName].Enabled=True

and again got the error cannot find the object 'forms!MyFormName!MySubformName!MyComboBoxName.'


Is this happening because it is not a text box, but a combo box?

[trolleri]

Anyone who sees the error?

You can dowload my database here: to begin! 55 - CRF4 nye felter.zip

And find instructions on how to get to the specific combo box here:


I have tried the codes mentioned in my previous post, but still cannot get the first column of combo boxes under the headline “The Symptom Checlist” to unlock the second column of combo boxes (greyed out), when selected a value not “0”. I get the error messages as described in the post above.

[amrut]

Check this http://access.mvps.org/access/forms/frm0031.htm for syntax for sub forms

[trolleri]

Check this http://access.mvps.org/access/forms/frm0031.htm for syntax for sub forms

Wow it worked, had to use [brackets]