Query does not pick up text box

[ryan-hallahan]

Hi,

I have a query that takes a value from a text box and queries a row out
of a table based on that value. The query works fine when my main form
is sitting open. However, I have a button on the main form that when
clicked, runs through a bunch of code. I use the query to create a
recordset while that code is running. However, while the code is
running the query will not pick up the value in the text box for some
reason. It just returns an empty table.

I have checked and the text box value is what I want it to be.

Thanks a lot and I appreciate any help you can give!
Ryan

 

[Mark M]

It might be the way you're building the SQL statement in your code. If you
post the pertinent parts of your code, perhaps a solution can be found.