how to select different check boxes

[allenpramod]

i am working with ms access. i got a problem with checkboxes. i create a checkbox in the form named chkbox with database fields.i am using continuous form so database fields are displayed with checkbox field. when i select one checkbox all checkboxes are selected. how can i select different checkboxes with database fields(teacher_name,school_name,dob,dob1) with chkbox. how can i write code for that to select database fields using checkbox. tell me i need it urgently.

thank you,
with regards,
pramod

[NeoPa]

This is not usual behaviour.
I would guess that you have all the CheckBoxes bound to the same field in your table. Is that right?
If so, that is your fix too (Bind them to the correct fields only - or unbind if that's right for your usage).

[allenpramod]

yes u r right, thank you i bound it to same field later that i used option group and bound it to all fields (teacher_name,school_name,dob,dob1) but when i click on the check box it wont check the box. try to help me please. one more thing i have date format dob field. for eg. 3.5.2000 i need last day of the month like 31.5.2000 how can i do for dob field tell me.

[allenpramod]

hi i solved date problem.now i am getting last day of month, problem is checkbox, i used an unbound check that is not in database, i bound all fields(teacher_name,school_name,dob,dob1) with checkbox(chkbox),when i am selecting checkbox it wont select the checkbox,last one empty record with checkbox when i click this it will select all records checkboxes what is the problem.i didnt understand, is there any code needed i didnt get any thoughts to my brain to write,please tell me i am in urgent

[NeoPa]

To find the last date of the month for any given date ([GivenDate]) :

DateAdd("m",1,CDate(Format([GivenDate],"1 mmm yyyy")))-1

if in VBA or within SQL is :

DateAdd('m',1,CDate(Format([GivenDate],'1 mmm yyyy')))-1

I'm afraid I can't follow the rest of what you're saying. Perhaps you could rephrase the position you're currently at. Separate different items into different sentences.