How do I do this?

I have an evalution forms that are entered either interactively by
participants or on paper and keyed in later.

The responses are 1-Excellent, 2-Very Good ...5-Poor.

The Evaluation is a Form of drop downs but I want a Datasheet for data
entry where users can just type in 1-5 vs selecting the associated
Label from the list.

The data sheet has the drop downs in it and I don't know enough about
Access and I have to do this fast (my niece needs it for a class)and
she asked my help

The Response Table is simple just RespondantID as a key, followed by
Q1,Q2,Q3... where I have the type as a look up to an Options Table.
Options Table is just ID as a key and Label. Here's where the 5
choices are.

Thanks

re: How do I do this?

enjayare3@hotmail.com (enjayare) wrote in message news:<e413548f.0406180245.4dfa0a39@posting.google. com>...[color=blue]
> I have an evalution forms that are entered either interactively by
> participants or on paper and keyed in later.
>
> The responses are 1-Excellent, 2-Very Good ...5-Poor.
>
> The Evaluation is a Form of drop downs but I want a Datasheet for data
> entry where users can just type in 1-5 vs selecting the associated
> Label from the list.[/color]

Okay, so you can have one form where the users enter strictly numbers.
This I assume you know how to do.

If you want to be able to choose Excellent, Very Good etc and have the
corresponding number stored in your table, use a combobox.
In the properties of the combobox:
column count=2
rowsource: SELECT NumericResponse, TextResponse FROM tblResponseList
ORDER BY NumericResponse;
Column Widths: 0;1
(the zero hides the first column - the one that gets stored, so the
user sees the text only).

HTH,
Pieter