Writing from a Query to a Text Box

[bella]

Hi guys,

Can anyone tell me how to write from a query to a textbox?

Say I have a Query behind a button that outputs some data
(String1, String2, String3)

Then I have a few text boxes on a Form, that need to display the values retrived from the Query:

So

TextBox1 should display String1
TextBox2 should display String 2
and so on...

how do i do this?

(they dont have to be textboxes...I just need to display what I retrieve in the Queries in an organized fashion on my form.

PLEASE let me know
Bella

 

[Calvin]

Lookup "DLookup Method" in VBA Help files.

Also Listboxes can be passed the SQL syntax into the RecordSource property and formated for multiple columns, in your case three columns and sized to only show one row of data (the first).