Form references/criteria

P

Pete Dochers

I am creating reports through queries whereby the query selects the criteria
of a supplier and dates that have been input on the Supplier form.

Everything was working perfectly until I closed the dbs and now its not.

When the report is run with the Supplier form open (as required obviously)
it asks me for each parameter query instead of taking it from the form.

Any suggestions? - it seems to be a permanent change.
 
L

Larry Linson

What code are you using to open the report? What version of Access? What
other details can you give? That would certainly help us to help you.

Larry Linson
Microsoft Access MVP
 
P

Pete Dochers

Here is my SQL for retrieving Purchase Records by currently viewed Supplier
and Dates on the Supplier Form.

SELECT Stock.Stock_ID, Stock.[Supplier_ ID], Stock.Artist_ID, Stock.[Picture
Name], Stock.Description, Stock.[Supplied Price ex-VAT], Stock.[Ticket Price
ex-VAT], Stock.[Date Arrived], Stock.Sold, Stock.[VAT Rate], Purchase.[Sold
Price], Purchase.Date, Purchase.Customer_ID, Purchase.Purchase_ID, Stock.[VAT
For Supplier], Supplier.[Supplier Name], Supplier.[Contact Name],
Supplier.[Number/Name], Supplier.Phone
FROM Supplier INNER JOIN (Stock INNER JOIN Purchase ON Stock.Stock_ID =
Purchase.Stock_ID) ON Supplier.Supplier_ID = Stock.[Supplier_ ID]
WHERE (((Stock.[Supplier_ ID])=[Forms]![Supplier]![Supplier_ID]) AND
((Stock.Sold)=Yes) AND ((Purchase.Date) Between
[Forms]![Supplier]![startdate] And [Forms]![Supplier]![enddate]));


I find this wierd as it was working fine. It now asks for parameters instead
of taking them as instucted.

I'm using 2000 file format but with Office XP

Thanks for any help
 
Top