Help with passing parameter to query

  • Thread starter Thread starter Kevin Baker
  • Start date Start date
K

Kevin Baker

I have a text box on my form with a button..on the button, I have the
following code:

Me.List0.RowSource = "SELECT POMain.poid, POMain.Date, POMain.PONumber AS
[PO Number], POMain.Source, POSource.Name, POMain.EDI, PORECINFO.RecDate AS
[Receipt Date], PORECINFO.RecAmount AS [Receipt Amount], PORECINFO.RecNumber
AS [Receipt Number] FROM (POSource INNER JOIN POMain ON POSource.SourceID =
POMain.Source) LEFT JOIN PORECINFO ON POMain.poid = PORECINFO.RecPONumber
WHERE (((POMain.PONumber) like &"*"&[forms][POBrowseFrm][text39] ORDER BY
POMain.PONumber DESC;"

But the above doesn't work...can anyone help?

Thanks,
kevin
 
I have a text box on my form with a button..on the button, I have the
following code:

Me.List0.RowSource = "SELECT POMain.poid, POMain.Date, POMain.PONumber AS
[PO Number], POMain.Source, POSource.Name, POMain.EDI, PORECINFO.RecDate AS
[Receipt Date], PORECINFO.RecAmount AS [Receipt Amount], PORECINFO.RecNumber
AS [Receipt Number] FROM (POSource INNER JOIN POMain ON POSource.SourceID =
POMain.Source) LEFT JOIN PORECINFO ON POMain.poid = PORECINFO.RecPONumber
WHERE (((POMain.PONumber) like &"*"&[forms][POBrowseFrm][text39] ORDER BY
POMain.PONumber DESC;"

But the above doesn't work...can anyone help?

Thanks,
kevin
Click to expand...

Watch your quotes. You have double quotes within the string's double
quotes. Also you're missing the !'s in the forms!formName!ControlName
syntax.
Try...
= "Select ....etc. ...
like & '*' & [forms]![POBrowseFrm]![text39]
.... etc."
 
Back
Top