Iif Statement and OptionVAlue Frame

[k209310]

Ive never come accross this statement untill recently so im not at all sure how to use it but is it possible to change the field a query searches using the Iif statement that references the results of an OptionValue Frame.

If not not does anyone know of a way to change the filed a query searches?

Thnaks in advance

 

[DJN]

Use a case statement.

Select Case [Option Group Name]
Case 1
Do something
Case 2
Do something
Case 3
Do something
Case Else
Stop
End Select

David

 

[k209310]

Thanks for the replies. I knew you could call different queries from VBA i was just wondering if i could have the query change onstead. Thanks for clearing that up.

Chris