prient preview okay but actual printing causes #name? error

  • Thread starter Thread starter jillymc
  • Start date Start date
J

jillymc

I have a report that displays values collected from a form.
The Print Preview shows the values correctly, but when I actually print the
report (to a printer or pdf) the values show up as #Name? errors.

I have the values entered in controlsource field of the report as
[=[forms]![frmName]![formvaluename]

Any suggestions?
 
Yes, that turns out to be the problem.
The form opens in a popup window that obstructs the print preview. We were
closing the popup before printing.

Which brings up the question.....is there a way to have the print preview
window appear in front of the form popup?
Or, how could I pass the variables in the code behind so that it's not an
issue?

thanks.
Jill

Gina Whipp said:
jillymc,

Are you closing the form before the report actually prints?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

jillymc said:
I have a report that displays values collected from a form.
The Print Preview shows the values correctly, but when I actually print
the
report (to a printer or pdf) the values show up as #Name? errors.

I have the values entered in controlsource field of the report as
[=[forms]![frmName]![formvaluename]

Any suggestions?
Click to expand...


.
Click to expand...
 
Jill,

Instead of closing the form use Visible...

On Report's On_Close Event

Forms![YourFormName].Visible = True

On the Report's On_Load Event

Forms![YourFormName].Visible = False

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

jillymc said:
Yes, that turns out to be the problem.
The form opens in a popup window that obstructs the print preview. We
were
closing the popup before printing.

Which brings up the question.....is there a way to have the print preview
window appear in front of the form popup?
Or, how could I pass the variables in the code behind so that it's not an
issue?

thanks.
Jill

Gina Whipp said:
jillymc,

Are you closing the form before the report actually prints?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

jillymc said:
I have a report that displays values collected from a form.
The Print Preview shows the values correctly, but when I actually print
the
report (to a printer or pdf) the values show up as #Name? errors.

I have the values entered in controlsource field of the report as
[=[forms]![frmName]![formvaluename]

Any suggestions?
Click to expand...


.
Click to expand...
Click to expand...
 
That works perfectly!!!!!
Thanks for the Christmas present!!!
Jill

Gina Whipp said:
Jill,

Instead of closing the form use Visible...

On Report's On_Close Event

Forms![YourFormName].Visible = True

On the Report's On_Load Event

Forms![YourFormName].Visible = False

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

jillymc said:
Yes, that turns out to be the problem.
The form opens in a popup window that obstructs the print preview. We
were
closing the popup before printing.

Which brings up the question.....is there a way to have the print preview
window appear in front of the form popup?
Or, how could I pass the variables in the code behind so that it's not an
issue?

thanks.
Jill

Gina Whipp said:
jillymc,

Are you closing the form before the report actually prints?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

I have a report that displays values collected from a form.
The Print Preview shows the values correctly, but when I actually print
the
report (to a printer or pdf) the values show up as #Name? errors.

I have the values entered in controlsource field of the report as
[=[forms]![frmName]![formvaluename]

Any suggestions?



.
Click to expand...
Click to expand...


.
Click to expand...
 
Jill,

Glad to help!

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

jillymc said:
That works perfectly!!!!!
Thanks for the Christmas present!!!
Jill

Gina Whipp said:
Jill,

Instead of closing the form use Visible...

On Report's On_Close Event

Forms![YourFormName].Visible = True

On the Report's On_Load Event

Forms![YourFormName].Visible = False

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

jillymc said:
Yes, that turns out to be the problem.
The form opens in a popup window that obstructs the print preview. We
were
closing the popup before printing.

Which brings up the question.....is there a way to have the print
preview
window appear in front of the form popup?
Or, how could I pass the variables in the code behind so that it's not
an
issue?

thanks.
Jill

:

jillymc,

Are you closing the form before the report actually prints?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

I have a report that displays values collected from a form.
The Print Preview shows the values correctly, but when I actually
print
the
report (to a printer or pdf) the values show up as #Name? errors.

I have the values entered in controlsource field of the report as
[=[forms]![frmName]![formvaluename]

Any suggestions?



.
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top