Option Group Value won't display in Query when code is executed

[Ryanspad1]

Hello,

I have an option group stored on a form with 4 choices and am just trying to
usethe value selected in the option group within a query. Simple enough, I
can get the query to work just fine, displaying information based on the
choice made with the option until I execute the query from code. Then it
seems that the option group value is not available or is ignored and does not
work. What I'm noticing is that if I pause the code at the point where the
query is suppose to run and execute the query manually, no information is
displayed (option group value shows blank). However, if I stop the code
completely at that point and then run the query, the information is displayed
just fine.

Can anybody tell me what is going on here? I'm stumped.

Regards,
Ryan

 

[Linq Adams via AccessMonster.com]

If you want us to help debug your code for running the query we really have
to see it! Is the Option Group bound? What is your SQL statement?

 

[Ryanspad1 via AccessMonster.com]

Thank you for your reply. The option group was unbound and I was just using
a basic query to read the value from it using the Forms![Formname].
[OptionGroupName] and it was showing blank when the code was paused during
code execute. I think I figured out that it is actually working, but just
for some reason when code is being executed (but paused), the query does not
actually show the value from the option group. Not sure if I understand why
that would be, but regardless if I actually just let the code run and execute
the query, it works, so you can disregard this post unless you have some
insight as to why a query wouldn't return a value from a form (whether option
group or any other "unbound" field) while code is in break mode.

Thank you,
Ryan