Query from a Form Group buttons! Help!

[paul25_uk]

Ok...second post ever, this is driving me mad!

I have a form [Reviews], with one option group[grp_Location] containing 4 options, All (1), Premier House (2), Crookesmoor (3) and Woodbourn (4).

I have a query setup that populates the subform. This works for three options, 2,3 &4 however I can't find a way in the Criteria section of the query to show all records if the Grp_Location value ="1".

The Criteria i have done is as follows (No laughing please, i'm new). Anyone know how to finish or redo.

IIf([forms]![reviews]![grp_Location]="2","Premier House",
IIf([forms]![reviews]![grp_Location]="3","Crookesmoor",
IIf([forms]![reviews]![grp_Location]="4","Woodbourn","*")))

This works until I want to select "1".

Please help!

 

[Jon K]

Replace "*" with the field name e.g.

IIf([forms]![reviews]![grp_Location]="2","Premier House",
IIf([forms]![reviews]![grp_Location]="3","Crookesmoor",
IIf([forms]![reviews]![grp_Location]="4","Woodbourn",[Location])))
.

 

[paul25_uk]

Thanks

Tell me....

Should i feel this stupid?