Mark a query checkbox

[Guest]

I created one query to find the data i needed to "mark for delete", and I'm
trying to use a second query to refer back to the first and only "mark" those
part numbers for deletion. Is there a simple way for me to have this field
automatically "check" it self?

Thanks! Lisa

 

[Rick B]

Make your 'select' query into an 'update' query and update the checkbox for
all the selected records to a value of "true".

 

[Guest]

Use an update query for the first and update the field to -1 (minus one).

 

[Guest]

I changed my type of query to an update query -put the "true" in the "update
to" row. Now i'm getting an error of "mut be an updatable query". I think
it's because i'm trying to update a table - using this query. Is there a way
to update a table using a query? if so, is there a special way to classify
the table? Keep in mind the table i'm trying to update is a hyperlink to the
web.. Any feedback you can give me is GREATLY appreciated! Thanks again for
your help!
Lisa