Calling a report with a value. 1

[ncopeland]

Hi

I have the following line which is attached to a button on a form. I have a combo box for selecting a supplier which I move it into a text box.

DoCmd.OpenReport "SupplierPriceList", acPreview, , "[POHeader].[Supplier-Name]=" & Me![Supp]


I get the following error.

Run-time Error '3075'

Syntax error in query expresssion '([POHeader].[Supplier-Name]=ALL FIT)'.

ALL FIT being the supplier name passed from the text box.

Any suggestions greatly received.

KR

NC.

 

[JoeAtWork]

[Supplier-Name] seems be a text field, therefore you need quotes around it. Try changing it to this:

DoCmd.OpenReport "SupplierPriceList", acPreview, , "[POHeader].[Supplier-Name]= '" & Me![Supp] & "'"