Access 2007 - Form Creation

[p4ck3tl055]

Complete Access noob here - please be gentle with me.



I'm trying to create a form that allows entry of data into a table. The table would track the CEU training taken throughout the year by our employees.

Not so hard, except I want to be able to choose who attended a class by selecting a check-box next to their name. And of course that list will need to be generated from a list of employees in a table every time the form is called - changing based on the the comings and goings of employees.

I've tried to explain it a bit better with the attached picture. I hope you folks can understand what I'm after and can help me.

Thanks in advance...

[pbaldy]

If you want to consider a multi-select listbox instead of the checkboxes, I'd to this:

http://www.baldyweb.com/MultiselectAppend.htm

[p4ck3tl055]

Baldy:

Thanks for the reply!

I've used your code and tried to adapt it for my needs, but I'm still failing.

I've attached a copy of my database. What's happening is the data is not getting added to my "matrix" table. It's almost like the code is being ignored or something. I'll keep plugging away and learn more about what's going on, but I simply do not see where the code is failing.

Thanks again for the willingness to help.

[pbaldy]

Your button is tied to an embedded macro, not the VBA code. Look at the properties of the button, on the events tab. It should say

[Event Procedure]

there.

[p4ck3tl055]

Baldy,

Yeah I found that about 10 minutes after I posted here. But I did find the solution....Security Settings.

Somehow (in a fit of click-happiness I guess) I turned off notifications about VB code being dangerous and behind the scenes, Access was turning off all VB code. Well I found out where that was and have added a few places on my hard drive to the "Trusted" locations and now things are just peachy.

Which now means I can write more code and it may actually work...yay!

Thanks again for your help!! I'd still be intrested in getting the checkbox method to work, but this will work for a start.

[pbaldy]

For the checkbox method to work, you would have to have a subform bound to a table that had a field for it. If you use an unbound checkbox, checking one person would check them all. It's doable, but more work IMHO.