Interesting challenges

  • Thread starter Thread starter nerb61 via AccessMonster.com
  • Start date Start date
N

nerb61 via AccessMonster.com

I have created a one-time per user user database to collect data for
implementation of our software. I have come up against a couple of challenges
that I'm hoping you can help me with.
There are about 300 Questions divided into 90 Issues contained in 3
Categories. If the user answers NA or No or to the 1st Question in any Issue
- they should proceed to the next Issue (Issues are the main Form, Questions
are on subform). Also all other questions within issue should be marked as NA.

When user comes to end of Issue questions Next Issue should follow without
having to click outside subform. Issue should be marked as complete (label,
textbox, or subform - visible property when issue questions complete?) - not
sure how to accomplish this.
On load - look for incomplete questions - prompt user to go to.
Disable Print Report until all questions are complete.

I currently have a 3 Main forms frmClinicalIssues, CoreIssues,
Technicalissues with several subforms frmQuestions, frmResponses,
frmResponsesYN, ResponsesNA, frmIssueComplete

It works fine the way it is - it collects the data - displays information
based on user responses and outputs report. It's just not that user friendly.
Any ideas would be greatly appreciated.
 
Presumably you want the Survey to appear (to the user) to be on one Form.
That could be solved by adding your Forms to subForm Controls. You could add
subForms to the pages of Tab Control with no tabs or buttons visible
(Property Style = "None") and get the User to step through the Survey by
navigating the pages using Back, Next and Finish Command Buttons to change
the Tab Control Value Property.

You could use the Next CommandButton to validate each Form or subForm record.
If a valid record is entered set the Tab Control Value Property to the next
Tab Control Page.

If you really want to knock yourself out add code to the AfterUpdate events
of all subForm controls to test silently for a valid record and move on to
the next Tab Control Page if a valid record is created.

Auto validation won't work if any of the data entry is optional (any further
comments etc.) so you might go for a mixture of auto validation when all
fields are required, and clicking on the Next Command Button when it isn't...
 
Back
Top