Pass Variable textbox to query (Access 2010 - VBA)

[mark71]

Hi,
I've created in VBA an USerform named (form1) in which I've put one textbox1 and one clickbutton.



After fill textbox1 with a value and push clickbutton I would like to run this query based on fact that the variable in textbox1 is passed to SQL string , currently it doesn't work.

RS.Open "SELECT * FROM [VENDOR DATA] WHERE [Buyer]=Forms!Form1!textbox1.value"

The form has been created in VBA development area instead of automatic form on Access main application.

Do you have suggestion ?

[mercapto]

The value of the textbox cannot be inside a string("...").

The code should be somethig like:

Dim strSQL as string
 strSQL = "SELECT... WHERE [Buyer] = " & Me.textbox1
rs.open strSQL

Hope it helps

[mark71]

It works! thanks!