-
1
- #1
I am trying to make a form that, with the click of a button, creates multiple records from the data that I just entered. I need a date box at the top where I can enter a date. Below that, I need to have 10 rows of names and 3 check boxes for each. I will try to demonstrate below. <cb> means empty checkbox and <x> means checked check box:
<date box>
A B C
John <cb> x <cb>
Jane <cb> <cb> <cb>
Sam x x <cb>
Sally <cb> <cb> x
Some people may have only one box checked, others may have none or multiple boxes checked.
For each CHECKED box, I need a record created that has the person's name, the date that is typed in the date box, and whether it was A, B, or C. If a person has no boxes check, they don't need to have a record that day. If they have 2 boxes checked, they need a seperate record for each A/B/C response. So the table entries for the above form entry would look like this in the end:
Name Date A B C
John 10/29/03 0 1 0
Sam 10/29/03 1 1 0
Sally 10/29/03 0 0 1
I just can't figure out how to get a single form to let me create the multiple records. Since there will be about 100 names, I don't want a form where I have to make the records one at a time. Any help with this problem would be greatly appreciated. Also, I don't have a lot of knowledge of VB or SQL, so if you could tell me how to do it in Access without much coding, it would be easiest for me (i.e. create a make-table query where...and then). Thank you in advance.
<date box>
A B C
John <cb> x <cb>
Jane <cb> <cb> <cb>
Sam x x <cb>
Sally <cb> <cb> x
Some people may have only one box checked, others may have none or multiple boxes checked.
For each CHECKED box, I need a record created that has the person's name, the date that is typed in the date box, and whether it was A, B, or C. If a person has no boxes check, they don't need to have a record that day. If they have 2 boxes checked, they need a seperate record for each A/B/C response. So the table entries for the above form entry would look like this in the end:
Name Date A B C
John 10/29/03 0 1 0
Sam 10/29/03 1 1 0
Sally 10/29/03 0 0 1
I just can't figure out how to get a single form to let me create the multiple records. Since there will be about 100 names, I don't want a form where I have to make the records one at a time. Any help with this problem would be greatly appreciated. Also, I don't have a lot of knowledge of VB or SQL, so if you could tell me how to do it in Access without much coding, it would be easiest for me (i.e. create a make-table query where...and then). Thank you in advance.