Happy Fathers day to all you dad's out there!
I have a form (IntakeAssessment) to determine the level of care a senior resident requires. I have a list box that contains the areas that are measured to determine Level Of Care (LOC) and Cost. ie.
AREA Score ScoreDesc Bathing 0 Independent with bathing & showering Bathing 5 Standby assistance 2 times a week Bathing 10 Total assistance 2 times a week Bathing 20 Requiring assistance 2 times a week/or showers taking longer than 20 minutes Dressing and Grooming 0 Independent with dressing & grooming Dressing and Grooming 5 Partial assistance Dressing and Grooming 10 Total assistance Dressing and Grooming 20 Total assistance more than 3 times a day
etc.
The reason I went with a list box is because I want the end user to populate the areas and scores that are relevant to their agency (via a user form). The list box allows multi-select (yes, I know, I shouldn't do that) but I can't think of a better way to give control to the users or to show them the various choices they have. In my Intake form, the selections are passed to the IntakeAssessment table along with the PK (ResID), cost and LOC. What I'm wondering is if there is a way that I can keep users from selecting 2 items from one area. Like "Bathing - 0" and "Bathing - 5". Also, is there a way to group like items in a list box? I don't think there is, but just in case, I'm putting it out there. I am of course open to suggestions on a better way to handle this. The Areas, Scores, Score Descriptions, LOC and costs need to be dynamic.(right word?) I thank you in advance for any suggestions!