rodgerfields
Programmer
I've been fighting this for days and can't make it work. Now it appears I may be trying something that's not allowed!
The simple question is: Will Access allow me to run a stored Select query and return the result to a text box in the report. If so, how?
I'm doing this is the Detail_Format section of the Report code; maybe that's my problem.
I'd love to have one query pass all the results into their respective text boxes, but right now, I'd settle for doing one query passing one result to one text box!! (Don't shoot me, guys! I know how bad that sounds! But I'm desparate.)
Among the 10-12 things I've tried are:
- putting the query text in the text box Control Source
- putting the query in the code and returning it to the
report via "me.(txtboxname) = curResultOfQuery"
- opening the database in the code and running the query
(which I can't get to work AT ALL)
Obviously, there's a fundamental piece of this puzzle that I missed.
Any suggestions?
The simple question is: Will Access allow me to run a stored Select query and return the result to a text box in the report. If so, how?
I'm doing this is the Detail_Format section of the Report code; maybe that's my problem.
I'd love to have one query pass all the results into their respective text boxes, but right now, I'd settle for doing one query passing one result to one text box!! (Don't shoot me, guys! I know how bad that sounds! But I'm desparate.)
Among the 10-12 things I've tried are:
- putting the query text in the text box Control Source
- putting the query in the code and returning it to the
report via "me.(txtboxname) = curResultOfQuery"
- opening the database in the code and running the query
(which I can't get to work AT ALL)
Obviously, there's a fundamental piece of this puzzle that I missed.
Any suggestions?