Help with passing parameter to query

[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

 

[fredg]

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

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."