I need help...please

[Guest]

I have a form that will be used for staff evaluations. We use a range of 1-7
with a paragraph describing each number. I can't find a way in which to show
the description of the number and allow the user to choose the number that
corresponds with the description. This number will be used for calculations.
How do I need to set up my tables and how will that transfer to a form? I am
stuck. Please help.

(e-mail address removed)

 

[Al Camp]

Rebecca,
Responses to user questions in the Access newsgroups are submitted back
to the newsgroup, and not individual mail addresses.

Create a field in your table called EvalRating, and make it a Numeric
Byte field.
On your form, use an OptionGroup with seven checkboxes valued 1 - 7. Bind
that field to the EvalRating field in your table. The label for each
checkbox is where you'll indicate the description of each rating.
The user checks a box, say 3, and the 3 is stored in the EvalRating field
in your table.

How to set up your table, or how to create the form are questions that are
too broad for any meaningful written response.
Purchase any Access reference book geared to beginners, and learn how to
create tables, field types, and how to create a form for data entry. Or,
check into taking an Access Introductory course that might be available in
your area.
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

 

[Guest]

Thanks for your help.

Rebecca,
Responses to user questions in the Access newsgroups are submitted back
to the newsgroup, and not individual mail addresses.

Create a field in your table called EvalRating, and make it a Numeric
Byte field.
On your form, use an OptionGroup with seven checkboxes valued 1 - 7. Bind
that field to the EvalRating field in your table. The label for each
checkbox is where you'll indicate the description of each rating.
The user checks a box, say 3, and the 3 is stored in the EvalRating field
in your table.

How to set up your table, or how to create the form are questions that are
too broad for any meaningful written response.
Purchase any Access reference book geared to beginners, and learn how to
create tables, field types, and how to create a form for data entry. Or,
check into taking an Access Introductory course that might be available in
your area.
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

 

[Guest]

How do I bind the option group to my table? I don't see a place in properties
to do that.

 

[Al Camp]

The OptionGroup's ControlSource should be set to your EvalRating field in
your table. That is the field that will store tyhe value.
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions