writing a string into a SQL query

[habbabub]

i have a string in VB (eg. "test")that will cahnge depending on the input, ihow can i search for the string and display the data into a form?

i currently have this
"SELECT [Tasks].Staff_Name, [Tasks].Project_Title, [Tasks].Percentage_Complete, [Tasks].Tracking_Number FROM [Tasks] WHERE [Tasks].Staff_Name like [forms].[Main].[test] ORDER BY [Tasks].Staff_Name;"



but how can i make it so it spits the data into its corresponding feilds onto a form? (just like it would be if i performed a wizard?)

 

[Guus2005]

this is the x-th time you ask the same question.
Explore the northwind database, which came with Access.