Getting a simple condition to work

[KrissyB]

Hi,

I am trying to build a macro and utilize a condition. I have not used these before but think it would be super helpful to me.

I am running a query called QrySUPPLIER thats builds the table tblPRODUCTS with the fields UPC, Retal,....,Supplier.

However I want the macro condition to be run this query where the Supplier=8303 (I want to be able to change this periodically, thats why I want to use the condition column--easy for people to see and change and I want to figure out how to use the condition column in case it becomes helpful in the future.)

So I have an action of OpenQuery
and a conidtion of [SUPPLIER]="8303"
Giving me an error message of:
Microsoft acces cannot find the NAME "SUPPLIER" you entered in the expression.

What do I have to change? Do I have to specify table?

Thanks for any help you can offer!

 

[jfgambit]

In the Query add [What is Supplier?] to the criteria of the Supplier field. This will prompt you for the Supplier Number everytime the Query is run. You can then enter any of the Suppliers that you want to run the query for.

HTH


"I know what you're t'inkin', ma petite. Dat Gambit... still de suave one, no?"