VBA SQL Returning Statement, Not Value -

VBA SQL Returning Statement, Not Value -

i'm working listbox, , when click on row populate fields on sheet. if click work ticket 18, grab department, priority, assignee, etc. table , fill work order. when click on row, msgbox pop ticket number writing:

msgbox me.work_order_list.value

then when seek

ticnum = me.work_order_list.value strsql = "select description_of_problem work_orders " & ticnum & " = ticket_number;" debug.print strsql me.notes = strsql

my notes box print sql statement never run. doing wrong here? need populate many fields there faster way well?

thanks

me.notes = dlookup("description_of_problem", "work_orders", "ticket_number=" & ticnum)

that looking for. able delete rest of code , utilize each field. hansup!

sql vba ms-access