Problem with checkboxes in Access 2003

[majcher3310]

My problem is:

I'm trying to solve problems with my customers, some of them are paying me whole amount once, other pay 3 times a year and others 12times a year.
I put in a form 12checkbox-es each for every month. Now when user will select 2 or 5 different months to pay, i would copy those information’s into table.

Now i have different problem, how a table suppose to look like, i suppose to have only one field for all months, or separate field for each month.

Thank you in advance for your help.
I hope you will help to make my life easier :-)

I put screen shot from this form with months - it suppose to look like this :-)

http://www.fotosik.pl/pokaz_obrazek/...918c4ee73.html

[heifler]

Just add one field in your table to accept a number byte data type will work.
Here is where you will store a value from 1-12.
To populate or change this value in a customer form, just enter the value directly or use a combo box containing the values 1-12.
If you really want the check boxes, then place them in an option group with each unbound check box have the value it need to populate this new field.
Then on the after update event of the option group, set the new field to the value of the option group.

Bob Heifler

[NeoPa]

I'm sorry Bob, but links such as you posted are not allowed in technical posts on this site. I've had to remove them. Please review Signature Guidelines.