Can't Find Form durinf email code execution

J

John

I am trying to build code that opens the email app, addresses the email and
includes a subject line.

I built a macro code:
="Audit Number " & [Forms]![fAudits]![AuditNo] & ": Finding " &
[Forms]![fFindings]![OfficialFindingNo] & " :MCA #: " & [OfficialMCANo]

The code claims that it cannot find the form "fFindings". When I remove the
references to "fFindings", the script runs as expected, returning the finding
and MCA numbers. I've verified the name and spelling of "fFindings".

Additional info:
The command button to run the macro* is directly on a Tab Control (no
subform) within the form "fMCAs".
"fMCAs" is a subform of the form "fFindings".
"fFindings" is a subform (located on a Tab Control) of the form "fAudits".

* The macro is contained within a macro object and referenced by the command
button.
Audits Form Macros.cmdEmailAssignedTo : On Click

Any suggestions? Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Send Form and Subform in Email 1
coding between subforms 6
Hidding a sub form on a tab 6
Using SQL Query Code in Form Module to Return Record Count 2
Open Form with Current Record 7
Difficulty coding a questionair form 2
Form performance 6
Format of date in my code 3

Top