Pass Through Query with Form Parameter Problem

[papic1972]

Hi all,

I have an Access 2003 Frontend linked to a SQL Server 2000 backend. I have converted my select query to a pass through query in access.

The syntax i have used is:

SELECT LoadLineID, Suburb, Plant, LoadBoxNo, Abbrev, DriverID, DeliveryDate
FROM dbo.tblLocal
WHERE LoadBoxNo=1 AND DriverID = '137' AND DeliveryDate=Forms!frmLoadAllocation!cboAllocationDate;

I understand that SQL cannot parse the access form criteria Forms!frmLoadAllocation!cboAllocationDate. Can anyone help me on how to pass the cboAllocationDate value to the query correctly?

Many thanks!

 

[Galaxiom]

http://support.microsoft.com/kb/131534