Setting Textbox with SQL

[DS]

I want to set the data in a textbox using SQL but it doesn't seem to be
working, any help appreciated.
Thanks
DS




With Me.Textbox
..ControlSource = "SELECT SalesDetailsMoney.SalesID, " & _
"SalesDetailsMoney.QtyPrice, SalesDetailsMoney.BasePrice, Items.Tax " & _
"FROM SalesDetailsMoney INNER JOIN Items ON SalesDetailsMoney.ItemID =
Items.ItemID " & _
"WHERE
(((SalesDetailsMoney.SalesID)=[Forms]![CheckPreview]![TxtSalesID]) AND
((Items.Tax)=1));"
End With

 

[Duane Hookom]

You can't use a SQL string as the Control Source of a text box. You can use
domain aggregate functions such as in your previous post.

 

[DS]

You can't use a SQL string as the Control Source of a text box. You can use
domain aggregate functions such as in your previous post.

Thanks, I realise that now.
DS