Marking Query Results

[Popolou]

Marking Query Results as "Read"

Hey all,

Maybe someone who knows what they are doing will get further than me on this!

I need to be able to mark the results of a query with Yes/No data. To be more precise, each entry has a tickbox and i need to be able to "tick" the search results only while not affecting the remaining unfiltered data.

At the moment, i have a query set up so as to produce the results on specific criteria. This data is then displayed as a table from the query. As a macro, once the query completes and displays on screen, a MsgBox asks whether to "Mark all results as read?" with either a yes or no where it then puts a tick in the tickbox field of the entry (or not).

When choosing No, the macro simply ends. However, when choosing yes, i need the macro (or to call another process/function) that marks/ticks the results from the query only.

How can i do this?

Any advice would be gratefully appreciated.

Regards

Popolou

 

[maxmangion]

try using an update query, which will set your tickbox field to true for those records which you processed.

 

[Popolou]

Thanks for your input.

I came to that possibilty too however, i need the option to mark the results as 'read' or not and hence the macro with the VB.

Ideally, is there code that can do the same do i can enter it into the macro?

Thanks again

Regards

Popolou

 

[Popolou]

Well, i decided to revisit the situation with update queries. I required the procedure to confirm with the user to continue with the search and mark those results as "read". This was to exclude them for any further searches next time round.

I had initially created a macro to present the option to the user and use the result to call another procedure. However, thanks to the update query it seems this method already asks the user whether or not the change is required.

Thank you all for your assistance once again.

Regards

Popolou