Check boxes on a subform

[Dummy007]

Good Day Everyone

I appologize that this may be a very remedial question, and that many previous threads pertained to the general topic of check boxes, but as I am new to the world of access, I did not find any threads which i could apply to my following question.
I would greatly appreciate any help and guidance

What I am trying to accomplish is to set up a subform in which each record is linked to a check box. The check box would be used to select unique records for an upcomming search.
My problem: the check box which i have added to the subform (from the toolbox) is linked to all of the records. That is to say that when I check one box it checks all of the all boxes as well.

Is there any SQL language which i should be applying here?

Suggestions are much appreciated

Thanks a million in advance,

~ N' Take care ~

 

[ShaneMan]

I assume your subform is in continuous form and that the check box you added is unbound. I think, not sure, but you will need to add a bound check box in order to accomplish what your trying to do.

Hope I answered that correctly,
Shane

 

[Dummy007]

Hi Shane,

Thank you very much for your reply.
As I am unfamiliar with access, I am having difficulty trying to figure out how to set the subform's check box so that they are bound. Would I do this by changing the control source to an expression ( and if so, what would i put as an expression?) or would i write SQL language 'after click' so select the specified records?

Thank you so much!

~Kristian

 

[RuralGuy]

Same answer as the other thread Kristian,

You need a field in the underlying query/table of the SubForm to set as the ControlSource of the CheckBox (bind).