Adding a check box to continous forms

[adolph]

I have a query that is not updatable that is the recordset for a
continous form. I'm trying to add a check box to each form in the
continous form. So that when checked, I can run some VBS to uncheck an
underlying check box in a table the part of the query is based upon.

If I add the CB as unbound CB then clicking on it changes all the
other boxes as well. If I ad an extra field defaulted to 0 in the
non-updatable query, and then bind a CB to this field, then I can't
click on the check box in the continous forms.

Any suggestions

 

[PC Datasheet]

Use the Click event of one of the fields in the form.

 

[Doug]

Not sure I understand all of the details here, but I don't
think you can put buttons on continuous forms themselves.
You need to make them a subform and put the buttons on
their master.

 

[TC]

Sure you can. In design view, there is just one button. In continuous forms
view, there is a seperate button for each record. When you click one of
those buttons, it moves the focus to that record, then fires the (single)
button Click event.

HTH,
TC