Help using list boxes in Access to pass values to a query

[lovenigma]

Hi everyone,

I am working on a database that should have been done yesterday, haha. But I'm having some implementation issues that I'm stumped on!

I am using a form with three list boxes and three checkboxes so that a user can select the criteria that is sent to a query. The list allows for one criteria, while the checkbox (if checked) overrides the list box and returns all the options for that criteria.

I successfully implemented it for ONE criteria. But for the other two, it is prompting me for input when the query is ran. It appears as if the list box works correctly, but the checkbox is not.

The code that works correctly, which is placed in the query's criteria box, is:
[Forms]![Run Query Form]![SelectPlant] Or IIf([Forms]![Run Query Form]![AllPlants]=True,[Plant]![Plant_name],"")
But for the other criteria, it prompts the portion of the IIF function that says [Plant]![Plant_name]. I'm aware that this is how the brackets should work, but it works correctly in the first criteria and not the others!

Here's the database:
(My work proxy is blocking the attachment feature. Argh. Please use this link instead! I promise it's not malicious.) http://dl.dropbox.com/u/11833099/Sup...Management.zip


I'd appreciate ANY and ALL help. Or, if there's a different and easy way I could implement the same functionality. I'm amazed it's not included in Access already! (In a user-friendly format)

Thanks a ton!!

[apr pillai]

[Plant]![Plant_name] is not fully qualified as the earlier two cases.

If [plant] is a sub-form then you must qualify that [Forms]![Run Query Form]![Plant].form![Plant_name]

[lovenigma]

Okay that seems to be on the right track. But, the data I'm trying to pull from is actually a table. What would be the syntax in that case?
[Table]![Positions]![Pos_name] maybe?

[lovenigma]

On second thought, that isn't working. And the list box the DOES work correctly is pulling the data from a table with only [Plant][Plant_name]