how to create checkbox to check the ones that we want to select

[Marco]

Hi. I have a form with a subform. the form runs over a query.

I would like to have a check box to select only records that I need.

I tried to create a checkbox control on the form but then when I select one
it selects me all records.

I already try to create in the query but happens the same problem.

How can I do this?

Regards,
Marco

 

[KARL DEWEY]

Is your checkbox bound to the query and in turn to the table?

 

[Marco]

Hi. it's Unbound.

I don't have field in the tables to say, "CheckMe".

I tried, but because the base query that supports the form, is a non
updatablew query it doesn't work.

Do you think that my only change is to insert the query result into a empty
table and in that table I have a "CheckMe" field type Yes/No



Regards,
Marco

 

[KARL DEWEY]

Do you think that my only change is to insert the query result into a empty
table and in that table I have a "CheckMe" field type Yes/No
It is according to what you intend to do with the records. If you update
them then the orignal records still need updating.

Why not just use criteria in your query supplying records to the form?