Continuous forms with checkboxes?

[Guest]

I'd like to make a form sort of like the display in Hotmail - for each record
in the Continuous Forms there is a checkbox the user can turn on. Then I'll
put a "do it" button at the bottom to work on those checked rows.

But I can't seem to do this. When I simply add the checkbox as an unbound
control, there's ONE for the entire recordset -- clicking any one turns them
all on or off.

Suggestions?

 

[Sylvain Lafontaine]

With an unbound control, this is simply impossible to keep the value of
different states in memory. You must add a field to your recordset and link
your control to this field.

The easiest way of doing this is to add this new field directly into your
database. You can try to add it directly to the recordset but I can't
remember if you can do this with a connected recordset.

S. L.

 

[Guest]

Maury,

That's how unbound controls work. The checkbox in essence, belongs to the
form, not a particular record. To work around this, simply add a Yes/No
field to the form's underlying table.

If for some reason you don't want to change this table's strucure, you can
add an entirely new table with just the checkbox and the first table's key
field. Then base your form on a query of the two tables, linked by the key
field.

HTH
Sprinks

 

[Guest]

With an unbound control, this is simply impossible to keep the value of
different states in memory. You must add a field to your recordset and link
your control to this field.

I had a feeling this was the case. Oh well, the user appears to think Excel
is a better display anyway...