I've got it, thanks to all who contributed! I took Delerna's suggestion of adding a button to the form that opens the report when clicked.
Now on a related topic, does anyone know if there's a better workaround to the scientific notation problem (MSKB 180590, "Output to XLS Changes Text to Scientific Notation Number" ) than adding an apostrophe to the value? Some of my values have the form nnnnDnnnnn, e.g., "2006D00041 ",...
danielb1952
Last Activity: Sep 30 '09, 05:10 PM
Joined: Sep 29 '09
Location:
-
NeoPa,
I apologize for my ignorance of this subject, but I'm not sure what you mean by "run simply as a query". The second query, in fact, cannot run by itself but must be invoked only by virtue of running the form. Perhaps that's the problem, that I haven't constructed the query and/or form correctly?
And yes, I want to run a report based on the same data as that shown when you run the form which invokes...Leave a comment:
-
AJ,
Not sure if I explained it correctly. The combo box is on the form. So trying to follow your instructions, I changed the Record Source of the report to the combo box, using a form of [Forms]![frmMyForm]![Combo0], but this results in a Sorting and Grouping error for the report, and also results in a error when I run the report: "The record source [Forms]![frmMyForm]![Combo0], specified on this form or report does not exist"....Leave a comment:
-
How to connect a form to a report? (newbie question)
I have created a form that uses the results of two queries: the first query is used to populate a combo box and then the selected value in the combo box is used as a parameter for the second query. This works fine.
I have also created a report that displays the results of a third query, where the third query is identical to the second query except that it prompts the user to enter a parameter, instead of getting the parameter from...
No activity results to display
Leave a comment: