Using Check Boxes

[snypa]

Hi Guys

I'm having some trouble using checkboxes. I want the user to be able to select which columns they want updated for each record by selecting the appropriate check boxes and clicking save.

I have created the form but the problem that I'm getting is that if I check a checkbox on one record it then selects it for every other record which is not what I want. Could someone please help me with the best way to accomplish this task

Thanx in advance

 

[John Big Booty]

Is the check box bound or unbound? Is it on a form with single or continuous form view?

Any chance of posting a copy of the DB?

 

[snypa]

Sorry I'm a complete newby what is an unbound checkbox and I'm getting the user to view one record at a time, then they can select which ever combination of checkboxes they link. When they click next to go to the next record their previuos selection should be irrelevant

Cheers for the help

 

[John Big Booty]

An unbound control (Check Box in this case) is one that resides in isolation on a form ie. the data that is input to that control, is not store in a/the table to which the form is bound/linked.

 

[missinglinq]

That's the nature of the unbound beast! In order for a checkbox to persist in the proper state (ticked or unticked) as you go from record to record, it has to be bound to a field in your underlying table.

In Design View, select your checkbox, goto Properties - Data and use the dropdown box for the Control Source Property tp pick the appropriate field.

 

[snypa]

Thanx, you guys are legends

 

[snypa]

Sorry to bug again but how can I use these checkbox to determine what fields to update from this table. ie I want ti write a control statement that will update a certain field it the checkbox is checked and not update that field if its not. I have four fields that can be updated in any combination according to the checkbox selection

Thanx in advance