Report will not generate from pushing a button on the form

[TH]

Hi -
I am trying to run a report from my switchboard form. I keep getting the
following message "There was an error executing the command." When I try to
go to the report and run it from there instead of from the switchboard, I am
getting the error "The expression you entered has a function name that DCDO
can't find". Please tell me how I can fix this.

 

[Daryl S]

TH -

It sounds like a problem with your query. Open the query in SQL View and
copy/paste the SQL statement into your reply posting, and maybe we can help.

 

[John W. Vinson]

Hi -
I am trying to run a report from my switchboard form. I keep getting the
following message "There was an error executing the command." When I try to
go to the report and run it from there instead of from the switchboard, I am
getting the error "The expression you entered has a function name that DCDO
can't find". Please tell me how I can fix this.

By correcting the error in your code, or in the function... which nobody here
can see!

Please open the Report in Design view and post its Recordsource property. If
that is a Query, can you open the query successfully? If not, you'll need to
look at the Report's Properties to see if there is anything unexpected in any
of the properties on its Events tab.