Trouble Printing Linked Jpeg Image on Report

  • Thread starter cw via AccessMonster.com
  • Start date
C

cw via AccessMonster.com

I have this code on my Report:
-----------------------------------------
Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)

Me.Image11.Picture = Me.txtStockGraph

End Sub
----------------------------------------

When I open the Report I get " Type Mismatch" error.

The value for the Report comes from a Form with a Combo Box.

If I go into the Reports underlying query & manually put in the Criteria, it
works fine?
But won't work if I use this as my criteria: [Forms]!
[frmChooseNameOrPrintAllBlue]![Combo31]


Any ideas much appreciated.
cw
 
J

jalexander via AccessMonster.com

SA, Thanks for the response.

I may have taken the easy way out on this one & ended up doing the following:
1) Added an extra Text Box to my form
2) Record Source =[Combo31]
3) I then used it as the reference in my query's criteria as :[Forms]!
[frmChooseNameOrPrintAllBlue]![Text24]

This now works fine.
Try changing

Me.txtStockGraph

To

Me!txtStockGraph
I have this code on my Report:
-----------------------------------------
[quoted text clipped - 17 lines]
Any ideas much appreciated.
cw
 

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

Top