getting a value out of sql server into a textbox

[slowface]

hi there,

I just started experimenting with access (97) for developping a client application, connected with an ms sql server (2000).
I would like to limit all communications with sql server via pass-through-queries.
Thanx to this site and posted questions here I already figured out how to get data into the database and out of it again using access forms.

Now i made a query that returned a single string as result.
I want this string into a textbox, let's say 'txtBox1'.
Can any of you please tell me what's the best way to make this happen? I have been trying all day and did not get very far by now....:S...

thx...

 

[MrBelfry]

Hi

I had a similar need and found the answer in this thread
thread702-555365 that will help.

MrBelfry