Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Jan 2002
    Posts
    31
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Help with Logic (XP)

    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

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Help with Logic (XP)

    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.

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Manchester, Gtr Manchester, England
    Posts
    299
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Help with Logic (XP)

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •