Need access check box help...anyone?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hey all maybe you can help me out on this one. Im new to using access in
this fashion so i could really use as much help as possible. I am using
access to create a recall or personnel database using a form. I have it so I
can input all the personal information just fine but I included check boxes
to show a certain persons status. Now the problem I am having is that when
you are in one record and click the check box it clicks the check box for all
the records. So how do I get it so that when you click a check box it only
checks the box for that particular record? Thanks for any help possible!!
 
Hey all maybe you can help me out on this one. Im new to using access in
this fashion so i could really use as much help as possible. I am using
access to create a recall or personnel database using a form. I have it so I
can input all the personal information just fine but I included check boxes
to show a certain persons status. Now the problem I am having is that when
you are in one record and click the check box it clicks the check box for all
the records. So how do I get it so that when you click a check box it only
checks the box for that particular record? Thanks for any help possible!!
Click to expand...

The check box control on the form should be bound to a corresponding
field in the table.
1) Add a Yes/No field to the table .
2) If the Record Source for the form is a query, add the check box
field to the query grid.
3) Then open the form in Design View and drag the new field from the
Form's Field List tool button onto the form.
 
Back
Top