Incorporating text boxes are query parameters

[Stevestan1]

I have 2 text boxes that I want to use as the criteria for a column in a query. Right now I am using the expression "> [Forms]![Main]![Text3]" as the criteria for the column. Where "Main" is the form and "Text3" is the name of the textbox. Unfortunanly, when I run the query I get an error saying there is an error in this expression. Can anyone explain where the error is?

[beacon]

Are you putting quotes around the expression or were you just doing that for your post here?

[Jerry Maiapu]

Remove the quotes (" ")surrounding the expression and create a button to run the query from the form. Something like this:

 DoCmd.OpenQuery "your query name", acViewNormal, acEdit

And see if it works!

****Sometimes when opening (by clicking)query directly does not work**..

[NeoPa]

Steve, you've omitted your code and the error message that relates to the failure, but asked where you've gone wrong. Does this make sense to you?

[Stevestan1]

Hi Jerry, I am not trying to use the openquery function to run the query. Rather I am trying to find the command that goes into the "Criteria" line of a query that will compel the query to use the inputs on a form's textboxes to set the parameters for the query

[beacon]

I see a couple of things that you need to check and/or provide more information about before we can effectively (and efficiently) help you out. Otherwise, we're all just making guesses, everyone will end up frustrated, and your question will go unanswered.

So, that being said, please provide more information for each of the following items:

1.Do you literally have quotes around the expression you have in the "Criteria" section of your query?

If you are getting an error message and the criteria you have entered is literally ">[Forms]![Main]![Text3]" with the quotes, then you need to remove the quotes.

If you are getting an error message and you don't have quotes around your expression, then your expression is likely incorrect. Double-check the name of your form and the name of the textbox to ensure that the query is receiving data from the correct place.

2. What is the error message you are receiving?

NeoPa already asked you for this information, but I'm asking again. I think everyone that has replied understands what you are trying to do, but the lack of information is making it difficult to give you the answer you seek.

3. If your question, from your original post, is "Can anyone explain where the error is?", then the answer is yes we can and no we can't. The error is most likely in your criteria expression, but there's no way for us to know because you haven't provided the error message. How can any of answer where the error is when we don't know what the error message says?

I apologize if this comes across as rude, but you have to understand that we cannot read your mind and we don't have the luxury of looking at your database over your shoulder, so please, in the future, provide more details so we can assist you to the best of our abilities.