The update query should be restricted by referencing the same parameters as
the form's underlying query, so you'll need to keep the dialogue form open
(it can be hidden), and update the relevant column to the value of the
unbound checkbox in your bound form by referencing it as the 'update to'
parameter.
Call the update query in the unbound check box's AfterUpdate event
procedure. You should ensure than there are no records currently locked
by
your form by putting the following in the check box's AfterUpdate event
procedure:
Me.Dirty = False
before calling the update query, though in a multi-user environment
another
user could have locked one of the records of course.
The bound form should automatically refresh, but if not you can explicitly
do so with:
Me.Refresh
after calling the update query.
Ken Sheridan
Stafford, England
"Rich" wrote:
> Hi All,
>
> I have a form that displays a set of records from a parameter form.
> Once I have this subset of records, I want to include a checkbox in the
> form header to check or uncheck all records displayed for a field that
> is a checkbox in each record.
>
> I tried an update query, but it only gets the selected record. This
> seems fairly easy (as MS uses this in hotmail to select/deselect
> messages to delete or move), but can't seem to quite get my head around
it.
>
> Any help is greatly appreciated.
>
> Thanks,
> RJC
>
|
