how to stop the parameter from appearing

[haerion]

Hi all, I'm getting some problem when I try to do a cross reference that need a parameter that is an option group on the form, my sql is like this:

PARAMETERS [Forms]![ordersplitting]![chkweekday] Long;
TRANSFORM First([Vendor-Store-Status].Status) AS PremierDeStatus
SELECT [Vendor-Store-Status].Vendor
FROM [Vendor-Store-Status]
GROUP BY [Vendor-Store-Status].Vendor
PIVOT [Vendor-Store-Status].[Store#];

But each time I open the form, they asked me about the parameter 2 times, I can put anything or nothing and it will work, but is there a way to stop the parameter window to appear each time? The parameter is on another query from which I take the cross reference information. The code is like that:

SELECT Fournisseurs.[Supplier#], IIf(Trim([CompteDeVendorNo] & "")="",0,[CompteDeVendorNo]) AS Qty, [Vendor-Store-Status_Analyse croisée].[1], [Vendor-Store-Status_Analyse croisée].[2], [Vendor-Store-Status_Analyse croisée].[3]
FROM (qryVendorListBox0 RIGHT JOIN (Fournisseurs INNER JOIN WeekDay ON Fournisseurs.WeekDay = WeekDay.WeekDay) ON qryVendorListBox0.VendorNo = Fournisseurs.[Supplier#]) LEFT JOIN [Vendor-Store-Status_Analyse croisée] ON Fournisseurs.[Supplier#] = [Vendor-Store-Status_Analyse croisée].Vendor
GROUP BY Fournisseurs.[Supplier#], IIf(Trim([CompteDeVendorNo] & "")="",0,[CompteDeVendorNo]), [Vendor-Store-Status_Analyse croisée].[1], [Vendor-Store-Status_Analyse croisée].[2], [Vendor-Store-Status_Analyse croisée].[3], WeekDay.Number
HAVING (((WeekDay.Number)=[forms]![ordersplitting]![chkweekday]));


Thanks for your help!

Haerion

 

[Darrylles]

Hi haerion,

Which field is being requested?

Regards,

Darrylle

Never argue with an idiot, he'll bring you down to his level - then beat you with experience.

 

[lespaul]

First the form ORDERSPLITTING has to be open when trying to call this query. Secondly, the parameter declaration should be in the big query not the cross tab query.

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for database developers:
The Fundamentals of Relational Database Design
Understanding SQL Joins

 

[haerion]

Hi Lespaul,

You got a good idea over there

This got rid of the second box, but the first one still appear. Everytime I open the form, it appear right before the form open, I suppose it is because this query is on a list zone in the form, and the option is selected by default when the form open. Any idea to get rid of the last parameter input?

Thanks,

 

[lespaul]

what form are you trying to open when you get the parameter prompt?

Leslie

 

[haerion]

The form that got the parameter on it

 

[lespaul]

you're trying to open the form OrderSplitting?

And this form has a query tied to it that has the [forms]![ordersplitting]![chkweekday] parameter?

You can't do that, you can't open the query until AFTER you've open the form OrderSplitting and entered the information in the chkweekday edit box on the form.



Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for database developers:
The Fundamentals of Relational Database Design
Understanding SQL Joins

 

[haerion]

Hi Leslie,

First question is yes, I want to open the ordersplitting form.

Second, this form has a list box that get is info from a query tied to it that has the [forms]![ordersplitting]![chkweekday] parameter.

Third, this was working fine until I tried to add the cross reference into the query so I can get the status of a purchase order for each store for each supplier.

And last, the information is already selected by default, it is a option group that select by default the day of the week.