Parsing form field value to query

[CodeNemesis]

How to I take the value of my textbox and send it to a query?

[ZeBula8]

Dim sTextboxValue As String
Dim sSQL as string


sTextboxValue = TextBox1.Text

sSQL = "SELECT * FROM [yourtable] WHERE [yourField] = ' " & sTextboxValue & " ';"

[RobDog888]

You can gain access to any control on your form by using the Forms collection.
Forms![Form1]![txtTextBox1].Value ,etc.