Copy Check Box Values of a form to a table! 1

[samn265]

Hi,
I have a form that has many check boxes (over 50). After the user finishes check the boxes he needs to check, I would like to step through each check box and copy them all to a table. The fields in the table have the same names as the check boxes name but not necessary in the same order of entry.
How would you accomplish this in VBA? Any idea?
Thanks…


East or West Home is Best.

 

[PHV]

You really have a table with 50 boolean fields ?
Have a look here:

http://r937.com/relational.html

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886