Creating a Survey Form - Using a Text Box As Response e "other"

[Guest]

Hello:

I'm trying to create a survey in a form that will link to data in a table
for answers a,b,c,d, using a combo box or list box, but still allow response
e, which allows the survey respondent to type anything they wish in a memo
field. I know how to do the first part (display possible responses on the
form for the user from one table and record their responses in another
table). I'm having trouble with response e.

Here's a sample question

Question A1:

How did you find this web-site?

a. Referred by friend
b. Television ad
c. Newspaper ad
d. Direct mail adverstiesment
e. other _______________________

What kind of control would I use to allow the user to type their own answer
for response e, while still maintaining a fixed set of possible responses to
resonses a-d. If it's easiest to write the response in answer e to another
field that's OK (i.e., responses a-d are written to a field called QA1, while
response e is writtent to field QA1_Other). Obviously, the slicker solution
would be to write response e to the same field as a-d, but I have a looming
deadline and need something simiple.

Thanks.

 

[Jeff Boyce]

Chad

There's an excellent example of how survey databases can be constructed.
See:

Duane Hookom has a sample survey database at
http://rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane

 

[Guest]

Jeff:

Thanks for the quick reply. Duane's applications are a little too advance
for me for this project, but you gave me an excellent source for other
examples. I should be able to learn quite a bit from your source.