selection?

[wh00t]

I have a query which takes criteria from a form to generate a report, but what I would like is to make some of the form selection criteria optional

e.g. field in query called 'Plant' takes the information from the 'ProductionLocation' field in the selection form 'frmSCPSelect'

field in query called 'Product' takes the information from the 'Product' field in the selection form 'frmSCPSelect'

at the minute, I need to complete both fields in the form to produce records, but I would like to be able to select 'plant' and leave 'product' blank, and have the query produce the information for the selected plant.

 

[Hayley Baxter]

I had the same problem a while back and QBF was the answer to my problems I use it all the time now.

Have a look at the post by e2cheng

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=39950

Again if you want the sample you know where to find me. Apologies I can't attach this...maybe we'll get more space soon

Hay

 

[wh00t]

got round it with IIF

IIF([forms]![form]![field] Is Null,

.[Field],[forms]![form]![field])