<chuckle> well you don't sound anything of the sort
however what you ask is not necessarily all that easy
to convey via this medium and is also kind of
dependent on your implementation.
But I'll take a generic stab at it....
1) [Label Field for Question 1] [answer field(s)]
2) [Label Field for Question 2] [answer field(s)]
etc...
Database Table
QueryId Question Key Identifier
QueryText What gets displayed to the user
QueryFlag A flag or series of flags that indicates
whether the question is appropriate.
VBA Code
If QueryFlag indicates use question Then
LabelField = QueryText
End if
Then you can store the results as:
UserId The person answer the question
QueryId Question Key Identifier
QueryResult Answer to the particular question
I hope that helps.
--- eliotchs <[EMAIL PROTECTED]> wrote:
> Hi Dennis,
>
> Don't want to sound like an idiot but can you give
> me an example.
>
> Thanks
> Joe
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessVBACentral/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
