using data from a sql query

[habbabub]

how can i msgbox data from a sql query

Tasklist.RowSource = "SELECT [Tasks].Staff_Name,
WHERE [Tasks].staff_name = "josh"
[Tasklist].Requery

i tryed to use
msgbox Tasklist.Staff_Name
but i get an error message


any ideas

 

[Mile-O]

You need to refer to the Combobox/Listbox in which the query is the RowSource;

MsgBox Me.TaskList.Column([i]n[/i])

Where n is the number of the column in the combobox/listbox, bearing in mind that column numbers start from 0.