Help with Logic (XP)

Topic

New Reply

I am updating a database designed to track institutional knowledge. There are 400 skills/topics and each person should select those they are proficient at and identify their level of expertise. Because there are so many skills, the data entry form has an unbound checkbox for each skill. A command button loops through the checkboxes and writes the selected skill ids to a table. The user is then taken to a form based on the table to enter their skill level (i.e. beginner, intermediate, advanced). Everything works fine, except that if users go back into the form later, they can’t see what they’ve already entered. Any suggestions on how I can set up the form so that when it is opened, it scans the underlying table and selects the associated checkboxes on the form?

Thanks.
Brandon

Reply | Quote

Replies

Personally, I’d use a subform for the skills.

In the present situation, you can add code to the On Current event of the form to populate the check boxes. We’d need to have more information about the way the selected skills are saved to a table if you want help with the code.

Reply | Quote

Is each user expected to have some level of expertise (even beginner) in all 400 skills?

If not, maybe you could use a popup form with a list box which would allow the user to select their skills (the list box would display skills from a lookup list and would only display those not already selected – over time, as the user adds more skills the list would get smaller). Once copied to the relevant table (say tblSkills – a child of tblPerson) the skill info could be displayed on a subform (as suggested by Hans) for the user to enter their proficency.

You could create a report (based on the layout of your original data entry form) showing all possible skills with ticks for those the user has provided information on.

Reply | Quote