Option buttons are bound to numeric values. I'm not sure why you just
wouldn't create dropdowns for each question of "Safe" or "At Risk". I suppose
you could store 0 or 1 for safe and at-risk.

You could set the default values so only a single survey is available.
--
Duane Hookom
Microsoft Access MVP


"JS" wrote:

I need option buttons instead of combo boxes. I also only need this to
contain one "survey". I don't need response type or numerous surveys. I don't
want the user to have to pick what survey they want. I want the form to just
open up to the "survey" screen. I tried to use it to fit my application, but
it just doesn't seem to fit just right. Around 20 people will be doing these
observations monthly. Actually each person has to do four a month. I work for
a safety department and we are trying to find our biggest area of concern
when it comes to "at-risk" behaviors, as well as those things that we are
doing right.

"Jeff Boyce" wrote:

As I recall, you could use "At Your Survey" to build your survey, rather
than using as a model you'd tweak.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"JS" wrote in message
...
I am trying to create something of a survey database. I have seen the
sample
database "At Your Survey", but I am not sure how to tweak it to what I
need.
I have a form that is for safety observations. Supervisors will observe
procedures and mark them as "safe" or "at-risk". I have a list of things
they
can observe but they don't necessarily have to observe everything on the
list. For example:
1. Stair/Ladder Use
2. Elevated Work
They could observe one of these things and mark it as "safe" or "at-risk".
I
understand the concept of a table for questions and a table for answers
and
then another table for possible answers for each question. I need all of
the
possible observations to show up on the form, even if they are not
selected
as safe or at-risk. I am unsure how to set up the form or the response
table
from the form. I have been reading all the posts and I know that the "At
Your
Survey" is a good example, but I just don't know how to modify it so that
all
my observations show at once on the form. I also would like to have the
"safe" and "at-risk" options as option buttons if possible. Thank you.