put text box value into query

[fanfan2]

Hi, I'm new to VBA. I have 2 text boxes in a form, I'd like to get the user inputs from those 2 text boxes and then use it in a query, then use a command button to run the query. How can I do that?

In my query SQL view, I used forms!txtbox1 and forms!txtbox2 to get the values, but it didn't seem to work.

Do I have to use VBA to do it? How can I run a sql query in VBA?

Any help would be appreciated.

 

[CraigDolphin]

You need to specify which form the textboxes are located on:

[Forms]![YOURFORMNAMEHERE]![txtbox1]

[Forms]![YOURFORMNAMEHERE]![txtbox2]

 

[fanfan2]

I did specify, but I'm sorry I forgot to put it in my question above. I did use [forms]![formName]![textbox1].

Thanks for pointing that out.

 

[CraigDolphin]

How are you using these references in your query? If it's in the criteria row of the comparable field this should work.

One caveat: if your textboxes are located on a subform within another form then your reference will need to reflect that (see http://www.access-programmers.co.uk/forums/showthread.php?t=113860)

 

[fanfan2]

Thanks. I used those references in an expression. It didn't seem to have got the value from the txtbox. Should I write VBA code for the text boxes s.a. "after update"?

 

[CraigDolphin]

Are you sure the form is open when you run the query? (Don't laugh...seen stranger things happen). Do you get an error message or a prompt when you run the query?

How can I run a sql query in VBA?

Sorry, missed that part of the question before. It's pretty staright formward to run sql in vba.

first declare a string variable to hold the sql

Dim strSQL as String

then write your SQL

strSQL= "Select ...whatever...From ...TableOrQueryname... Where [FieldName]=" & Me.TextBox1 & " And [FieldName2] =" & Me.Textbox2 & ";"

then run it using

Docmd.RunSQL strSQL