Enter Parameter

[Knight of Nee]

Hi

For a project for college I have to make an access database for stock control. Part of this involves making an invoice for an order. For this I imported the Invoices report form the northwinds example database into my database. Once I did this, I changed the report source and all other fields to a query I have created which pulls the order details.

This works fine but when I run the report it asks for me to enter the Product ID parameter and I cannot get rid of it. I know this must be coming from the northwinds original report because I do not have a field any where in my database called ProductID.

Also I have tried deleted all of the fields, label etc from the report and it still does it even through the report is empty.

Can anyone suggest where this productID is coming from and how I might get rid of it. I have tried everything I can think off and its driving me mad!

Thanks in advance
Craig

 

[SydneyGeek]

Look at the underlying query for the report. If the productID field is there, delete it. If not, see if it calls on any other queries. These may be the culprits.
Bottom line: if your form/report is based on a chain of queries, the missing field could be in any of those queries.

Denis

 

[Knight of Nee]

Hi

I dont think it is the query i am using which is doing it, as when i run the query on its own i dont get the box up asking me to enter it.

do you have any other suggestions as to what it might be?

 

[Norie]

Check the Order By property of the form.

 

[mdmilner]

I realize the problem is probably very fixable, but, you might do well to just rebuild the form using the wizard interface yourself. It (form builder wizard) really doesn't do a bad job doing basic tasks.

Mike