By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,903 Members | 1,856 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,903 IT Pros & Developers. It's quick & easy.

#Name Error in Linked Combo Box Field in Printed Report

P: n/a
I am creating a series of custom reports, whose parameters are
specified through combo boxes in a form, which then generates a custom
report based on a series of calculation queries. My problem is
this...at the top of the report I've inserted several text boxes which
link to the combo boxes on the entry form, and are supposed to show
which parameters a particular report is being generated from. On the
screen, everything looks great and works fine. However, when printed,
these text boxes show a #Name error. Anyone encounted this before or
know what may be going on here?

Thanks in advance

Hawk
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
By "on the screen", do you mean that it looks correct in Print Preview, but
that when you actually print the report you get the #Name error?

Three things I can think of right off hand. 1) Is the printer driver set for
"draft mode" or something similar? 2) Are the control names and field names
on the report the same name? I would expect this one to not work in Print
Preview either, but may be worth checking. 3) Is the form still open when
you preview the report but being closed before the report is actually
printed?

--
Wayne Morgan
Microsoft Access MVP
"hawk" <fo********@yahoo.com> wrote in message
news:ff************************@posting.google.com ...
I am creating a series of custom reports, whose parameters are
specified through combo boxes in a form, which then generates a custom
report based on a series of calculation queries. My problem is
this...at the top of the report I've inserted several text boxes which
link to the combo boxes on the entry form, and are supposed to show
which parameters a particular report is being generated from. On the
screen, everything looks great and works fine. However, when printed,
these text boxes show a #Name error. Anyone encounted this before or
know what may be going on here?

Thanks in advance

Hawk

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.