OpenReport using a field name from a query

[RalphBenoy]

I have not much programming experience but would like to OpenReport in Access using a field name from a query.
I have a number of different reports.
I have a query that defines which report I want to open.
But the OpenReport command seems to only accept a report name not variable

eg:
OpenReport
Report Name Forms![Menu_Preview_Report_Project_Cost_Original]![Lst_Stage_Letter_File]

or

DoCmd.OpenReport:=Forms![Menu_Preview_Report_Project_Cost_Original]![Lst_Stage_Letter_File]

Could anyone please help

[PhilOfWalton]

Try

DoCmd.OpenReport Forms![Menu_Preview_Report_Project_Cost_Original]![Lst_Stage_Letter_File]
 

That assumes that Forms![Menu_Preview_Report_Project_Cost_Original]![Lst_Stage_Letter_File] evaluates to a string

Phil

[RalphBenoy]

Hi PhilOfWalton,
Thanks for your reply. For some reason the command does not take the string. Is there any other advice you could give me. Thanks Ralph

[RalphBenoy]

Hi PhilOfWalton
When I say string I mean path to a query that contains a field.

[PhilOfWalton]

OK Lets do some diagnostics.

Presumably you have something like a List Box or Combo Box that shows the name of the report and assume the bound column is Column1 showing the report name.

Let's call it MyCombo

So try this air code

Sub MyCombo_AfterUpdate
   Dim ReportName as String
   ReportName = MyCombo
   Debug.Print ReportName
   DoCmd.OpenReport ReportName
End Sub
 

Does the Debug give you the correct report name?

Phil

[RalphBenoy]

Thanks PhillOfWalton,
I really appreciate your assistance.
I will try this today and give you feedback later.
Regards
Ralph