Hiding bound controls

[Guest]

I have a page that displays questions. The user enters their answer to the
questions and the data is written to the database.

I need to be able to hide certain questions based upon who is answering the
questions.

I have created the table that holds which questions should be visible based
upon who is answering. I need to know how I can hide the questions along with
the input controls and not leave big blank spaces on the form where the
questions are hidden.

Please help!

Thanks

 

[Guest]

doable, but tedious. To hide the controls and not allow them to be accessed,
use the Enabled and Visible properties of the controls.

To avoid the gaps, you will have to use the Move method.

 

[Sandra Daigle]

Your questions should probably be in a separate table - one row per
question. Then then answers would be stored with one row per question per
user, displayed for data entry in a continuous form (or subform). Using this
approach it would be easy to eliminate certain questions for certain users.
Duane Hookom has a good example of a survey/questionnaire database and the
proper structure. You might want to take a look at it:

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane