Print Preview Trouble

[gmatriix]

Hello All,

I have the following code attached to a button

Private Sub DraftPreview_Click()
    Me.Refresh
    
    DoCmd.OpenReport "draft quote", acViewPreview, , "ProductID = forms!product!productid"

Not much to it however, I changed it to be linked to a SQL table instead. The table it is connected to now show "productid" like this "product id" I have tried it both ways.

Like this "

Private Sub DraftPreview_Click()
    Me.Refresh
    
    DoCmd.OpenReport "draft quote", acViewPreview, , "Product ID = forms!product!product id"

And it wants me to enter in a ProductID parameter

And like this

Private Sub DraftPreview_Click()
    Me.Refresh
    
    DoCmd.OpenReport "draft quote", acViewPreview, , "ProductID = forms!product!productid"

And I get an runtime 3075 error. This seems like this should be simple but it driving me crazy.

Any Ideas?

 

[pbaldy]

I'd concatenate the form reference, as demonstrated here:

http://www.baldyweb.com/wherecondition.htm

Also, if the field has an inadvisable space in it, you have to bracket it:

[Product ID]