create a form with "active" questions only

[Guest]

I want to create a a customer satisfaction survey form to be entered by the
staff in our business. My problem is that I'd like to have a list that can
be changed by the staff at will. I was going to create one table/form with
all questions that they can make active/inactive. No problem

I then want to have a form that shows the active questions only (form box
tool?) with the "satisfaction level" associated with that question and the
customer number. My plan was to create one table that has the customer
details as the main form. Then a subform with a list of completed questions
with the level of satisfaction. How do I get the active questions listed in
the subform with the satisfaction level? How do I get the answers back into
a blank table with the customer number and date the survey was completed?

Thanks.

 

[Allen Browne]

If you have a yes/no field indicating if the question is Active, you can
create a query and use the criteria to choose just the active questions.
Then use this query as the Record Source for your form.

There's a good example by Duane Hookom of how to build a questionaire
database. Download his database for current versions of Access:
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='At Your Survey 2000'

Or, if you are using Access 97:
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='At Your Survey 97'