A
Axess08
I am designing a rather hefty database, so to limit the length of 1
particular form I created a table (i.e. "List - Exam") with multiple values
that I am using another table (i.e "Exam") to reference as a combo box (a
limited drop-down list to prevent the data enterer from inputting additional
data that is not in the list). There are multiple field headings in "Exam"
Table with the same setup but of course different Table/Query limitations
that relate to each field heading.
Ok, so my question is, can I (in the form -"Exam Form"- that references
"Exam" Table) edit a text box (that will be placed next to a drop-down list)
that will reference the values that can be selected in the drop-down list?
And (more importantly) can I based on the value selected in the list/combo
box export a specific numerical value for the text that is in the list box?
The idea is that I want the data enterer to slect something like medical
related data that can be quatified with a number and in the end sum up the
values like a scoring system.
Example: Injury Type (List/Combo Box) = Head Injury, Stomach Injury, Toe
Injury, Not Applicable
For "Head Injury", export numerical value 3
For "Stomach Injury", export the numerical value 2
For "Stomach Injury", export the numerical value 1
For "Not Applicable", export the numerical value 0
Summing values in forms is an easy expression builder, so that shouldn't be
a problem. I hope this isn't too complicated a problem. I hope someone can
help!
particular form I created a table (i.e. "List - Exam") with multiple values
that I am using another table (i.e "Exam") to reference as a combo box (a
limited drop-down list to prevent the data enterer from inputting additional
data that is not in the list). There are multiple field headings in "Exam"
Table with the same setup but of course different Table/Query limitations
that relate to each field heading.
Ok, so my question is, can I (in the form -"Exam Form"- that references
"Exam" Table) edit a text box (that will be placed next to a drop-down list)
that will reference the values that can be selected in the drop-down list?
And (more importantly) can I based on the value selected in the list/combo
box export a specific numerical value for the text that is in the list box?
The idea is that I want the data enterer to slect something like medical
related data that can be quatified with a number and in the end sum up the
values like a scoring system.
Example: Injury Type (List/Combo Box) = Head Injury, Stomach Injury, Toe
Injury, Not Applicable
For "Head Injury", export numerical value 3
For "Stomach Injury", export the numerical value 2
For "Stomach Injury", export the numerical value 1
For "Not Applicable", export the numerical value 0
Summing values in forms is an easy expression builder, so that shouldn't be
a problem. I hope this isn't too complicated a problem. I hope someone can
help!