Update Highlighted Records?

  • Thread starter Thread starter Dan
  • Start date Start date
D

Dan

I have a form with a subform in datasheet view. I would
like to be able to select multiple records in this
datasheet view and perform an update query on the selected
records. Is this possible? I was thinking of putting a
button on the form to perform the query, but don't know
how to have it just work on the highlighted records. Any
help is appreciated.
 
Dan,

I don't know if this is possible, but I can think of a
quick and dirty alternative: add a yes/no field to the
table where your subform gets its data from, set default
to No, and add the filed in the subform. From within the
subform, tick the box in the records you want the update
query to run on, and have the query filter on Yes. This
should do the job.
You might also make the update query reset the yes/no
field to No on updating.

Nikos Y.
 
Back
Top