VBA to Embedded Macro

[mrmims]

Hello,

I have VBA code to open a report to a record currently open in a form.

DoCmd.OpenReport "rpt_All_Axis_Report", acViewReport, , "AxisNumber=" & Me!AxisNumber, acDialog 

The code works great in VBA to open the report to the current record.

How do I do this in an Access 2010 Macro Builder in the Where Condition? It does not work when I add "AxisNumber=" & Me!AxisNumber to the where condition

Thank you for your help

[pbaldy]

Me is only valid in VBA. You'd need the full form reference:

http://access.mvps.org/access/forms/frm0031.htm

[June7]

Have to ask - why macro if you already have the VBA? Is this now or intended to be a web database?

[mrmims]

Thank you for the replies.

I'm sorry, but I don't quite understand the link to the webpage about correct syntax.

And I am trying to modify for a Web Database and get rid of as much VBA as possible

Thank you

[June7]

You could open the expression builder wizard - click the ellipsis/wand at the right end of Where Condition.