Last Revision for each Drawing

[lmsm76]

I've start with access 2010 about a month ago, and thanks to this forum i've learn a lot. Meanwhile I have a problem that it is driving me crazy.

Table1: Drawing | Revision
Query: Table1
Form: Continuous Form based on Query

I need to have a check box "True/False" that just list the last revision for each drawing when is marked or all fields when not.

For what I've seen I need a double Query, but how to ativate this when the check box is marked or not.

Any Idea?

 

[lmsm76]

Meanwhile I was able to solve one of the problems using a sub-query.
Now without the criteria it works, but when I want to list all files it is not possibly.
Attach there is a small sample...

Some help? :banghead: