Checkbox In MainForm to make a record in subform

[Jims Chan]

Goodday to all expert,

I m new in access and trying to create a quotation mainform with subform.
main have some field likes client, address, etc. Also, i would like to create 3 individual checkbox named checkbox1 represent banana, checkbox2 represent papaya & checkbox3 apple.
If all checkbox is checked, i want the 1st line of subform item to show banana and 2nd line show papaya and so on.
if only checkbox1 and 3 is checked, then 1st line of subform item to show banana then 2nd line show apple.



how to do it in the simple way in vba or macro???

[ssanfu]

Not a lot to go on, so this will be pretty general.

I would create a sub that will set a filter on the sub form recordset - lets name the sub "SetFilterSubForm".
In the after update event of each of the check boxes, call the sub "SetFilterSubForm".

The code in "SetFilterSubForm" is based on the code by Allen Browne at http://allenbrowne.com/ser-62code.html.
The description of the code is at http://allenbrowne.com/ser-62.html.

[Jims Chan]

Still stuck in here... hehe
in the main form have check box of motor insurance, enhanced road warrior, puspakom inspection & roadtax.
if checkbox of motor and roadtax is checked, then 1st item in subform will be motor then follow by roadtax.
else if 4 checkboxes are all checked, then all 4 item will be include in the subform.
what are the way to do it?
thanks in advance.

[ssanfu]

if checkbox of motor and roadtax is checked, then 1st item in subform will be motor then follow by roadtax.
else if 4 checkboxes are all checked, then all 4 item will be include in the subform.

Maybe I misread.....If you check "roadtax", do you want to only display the records in the subform that match "roadtax" or ADD a record to the subform for "roadtax"?

[Missinglinq]

Checkbox In MainForm to make a record in subform

Maybe I'm wrong, but I don't think the OP is talking about filtering the Subform...I think he's talking about generating Records on the Subform, dependent on what Checkboxes are ticked on the Main Form, which is kind of strange. I suspect that he should have a Combobox on the Subform to select an item for each Subform Record, instead.

Of course, my head is still spinning trying to go from 'papaya' to 'enhanced road warrior!'

Linq ;0)>