Parsing form field value to query

**CodeNemesis** · Feb 24th, 2005, 07:42 AM

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

**ZeBula8** · Feb 24th, 2005, 10:54 AM

Code:

Dim sTextboxValue As String
Dim sSQL as string


sTextboxValue = TextBox1.Text

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

**RobDog888** · Feb 24th, 2005, 12:33 PM

You can gain access to any control on your form by using the Forms collection.

VB Code:

Forms![Form1]![txtTextBox1].Value ,etc.

Thread: Parsing form field value to query

Thread Tools

Display

Parsing form field value to query

Re: Parsing form field value to query

Re: Parsing form field value to query

Posting Permissions