Query does not run

[ryan-hallahan]

Hi,

I have a query that gets one row from a table based on a value in a
text box on my main form. The query runs fine when the program is not
running, however during execution the query for some reason will not
read the text box. It just queries nothing. I have never had this
happen before.

I put a stop in the program and the text box value is what I want it to
be, so I am confused.

anyone have any suggestions? Thanks!

 

[Joseph Meehan]

Hi,

I have a query that gets one row from a table based on a value in a
text box on my main form. The query runs fine when the program is not
running, however during execution the query for some reason will not
read the text box. It just queries nothing. I have never had this
happen before.

I put a stop in the program and the text box value is what I want it
to be, so I am confused.

anyone have any suggestions? Thanks!

I am a little confused.

* query runs fine when the program is not running,
* during execution the query for some reason .. It just queries nothing

What program are you talking about? If Access is not running how can the
query run?

 

[ryan-hallahan]

Hi,

What I mean by running is that I have a button on the form, when the
button is clicked I have a bunch of code that runs. while that code is
running is when I need the query to get the info. but if I am just in
access before I click the button the query runs fine. hope that clears
it up.

 

[Joseph Meehan]

Hi,

What I mean by running is that I have a button on the form, when the
button is clicked I have a bunch of code that runs. while that code is
running is when I need the query to get the info. but if I am just in
access before I click the button the query runs fine. hope that clears
it up.

Does the code run the query or are you trying to run it manually while
the code is running?

 

[ryan-hallahan]

the code changes a value in a text box, and then tries to use the query
as a recordset. the query pulls the value from the text box. for some
reason after the button is clicked, the query does not take the text
box value. ive done similar things before, i don't know why this
doesn't work. thanks for your help!

Ryan