Developing a skills DB. Users will enter personal info., FName, LName, Phone...
Then will select from 5 CBoxes (w/ not limit to list)the skills/abilities that they have.

Chances are the users will have more than one set of s/a so I would like to add a button to save the record, keep personal info visible and clear the CBoxes for additional entry. I've tried several approaches and belive that I'm making this more difficult than it is.....
VB challenged.......

Any assistance would be greatly appreciated. Thanks in advance.

I've done something similar. What I did was have three tables, staff details, staff skills and skills (with the pre-entered defined skills). They were linked one staff to many staff skills and one skill to many staff skills. I then had my staff form with a staff skills subform. That way they could pick as many skills as they liked from the skills table.

HTH

I really like your idea! Tried it, but unfortunately it does not work properly (my limited knowledge base).

I created the tables and subform w/ 1-many.
What I have are the CBoxes that are synchronized (now on the subform).
So, first CB user selects year, second CB General skill, i.e. science. Third CB, select from organic, analytical, etc... and on it goes. (Worked well on just the main form).

What happens when the main form is now opened are several parameter queries tied to the subform. Changes were made in the queries to relate to the subform.

Another potential problem that I see is that as the user enters the second, third, etc... duration and skills/abilities, the previous data will be cleared due to several re-queries(required)....

Again, thank you for your assistance and thanks in advance!

Got it to work and it works great!

Just needed [Forms]![Main]![Subform]!General instead of {Forms]![Subform]!General in the row source query.

Thanks!