I have a table with 12 questions. I want the user to see and answer each question yes/no and comment on each question. I'm having trouble getting all the questions to appear with the "yes/no" and "comments" columns. This will eventually appear [as a subform?] on a tab on a form.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Need to create a user survey based on questions in a table.
- Thread starter ElleS
- Start date
I'm not sure what your question is exactly, but "a subform on a tab on a form" sounds awfully crowded. Especially with a comments field.
I use an audit form with checkboxes. Depending on the selection for each question, a comment may be required. On the before update of each option group, I check the value and if it is "Unsatisfactory", a pop-up form opens for the required comment.
It gives me a lot more flexibility with space on the form.
You could even have the comment displayed in a label or textbox right below the yes/no option.
Of course, maybe space is not the issue. Post back with a bit more detail and we'll see what we can do.
John
Use what you have,
Learn what you can,
Create what you need.
I use an audit form with checkboxes. Depending on the selection for each question, a comment may be required. On the before update of each option group, I check the value and if it is "Unsatisfactory", a pop-up form opens for the required comment.
It gives me a lot more flexibility with space on the form.
You could even have the comment displayed in a label or textbox right below the yes/no option.
Of course, maybe space is not the issue. Post back with a bit more detail and we'll see what we can do.
John
Use what you have,
Learn what you can,
Create what you need.
- Thread starter
- #3
Space isn't the issue, yet. I'm having trouble creating the "survey". You mentioned audit form, which may be what I need to create. I looked in Access Help and didn't get a response to audit form. Is that something I can make from two tables? I'm trying to use both my Questions table and a Details table.
- Thread starter
- #4
To John,
I may have responded in the wrong place:
Space isn't the issue, yet. I'm having trouble creating the "survey". You mentioned audit form, which may be what I need to create. I looked in Access Help and didn't get a response to audit form. Is that something I can make from two tables? I'm trying to use both my Questions table and a Details table.
I may have responded in the wrong place:
Space isn't the issue, yet. I'm having trouble creating the "survey". You mentioned audit form, which may be what I need to create. I looked in Access Help and didn't get a response to audit form. Is that something I can make from two tables? I'm trying to use both my Questions table and a Details table.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question