Shooting a SQLstring directly in a textbox 1

[Xenocide]

Hi

Is it possible to put a SQLstring I did in my VB code directly in a textbox?

 

[PHV]

What you want in your textbox, the SQL code or the dataset ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Xenocide]

Well I would like the Textbox to show the result of a on the flyquery

doing like this

lst3.RowSource = "Select Table850.Depense " & _
"FROM Table850 " & _
"WHERE Table850.Maitre = '" & lst1.Value & "' " & _
"AND Table850.IdEngagementA <> '" & lst1.Value & "' ;"

but instead of doing it for a listbox I would to do it for a textbox.

 

[PWise]

if you want just 1 value take a look at dlookup
if you want all the values you can open a recordset and loop trhu the set and append it to the textbox

 

[Xenocide]

thanks pwise.. I never really used a dlookup before

care to point me to some exemple ?

 

[PWise]

dlookup("Depense","Table850","Maitre='" & lst1.Value & "'AND IdEngagementA <> '" & lst1.Value & "'")

 

[Xenocide]

wa it work perfectly and at the same time solve 2 other problem I had

Thanks a lot pwise