Blackelise
aka Andrew
- Local time
- Today, 15:53
- Joined
- Jun 13, 2012
- Messages
- 35
Hi,
Please please could I have some help with this, it should be simple but it just does not work! :banghead: odd thing is that I though I had it working at one stage but now I'm notso sure!
I have a form with a Print button on it.
I have a report (that is surposed to print the information on the form).
Both the form and the report have a field called EstOrd_Number.
The idea is that I have an estimate shown within the form, I wish to print it off so I click the print button, this should load up the report with the same order number (EstOrd_Number) as that on the form - I am using preview rather than print for testing only.
I have used both a macro and coding both method fire up the report on the first record and not the correct EstOrd_Number. I have hunted around and tried diffferent ideas but to not avail.
the coding is:
Both EstOrd_Number & Me.EstOrd_Number = the the select record to print.
I'm lost - any ideas welcome.
Cheers
Please please could I have some help with this, it should be simple but it just does not work! :banghead: odd thing is that I though I had it working at one stage but now I'm notso sure!
I have a form with a Print button on it.
I have a report (that is surposed to print the information on the form).
Both the form and the report have a field called EstOrd_Number.
The idea is that I have an estimate shown within the form, I wish to print it off so I click the print button, this should load up the report with the same order number (EstOrd_Number) as that on the form - I am using preview rather than print for testing only.
I have used both a macro and coding both method fire up the report on the first record and not the correct EstOrd_Number. I have hunted around and tried diffferent ideas but to not avail.
the coding is:
Code:
Private Sub Command57_Click()
'Calls the EstimatePrint for Review
DoCmd.OpenReport "EstimatePrint", acViewPreview, , "EstOrd_Number = " & Me.EstOrd_Number
Debug.Print EstOrd_Number & " ..." & Me.EstOrd_Number
End Sub
Both EstOrd_Number & Me.EstOrd_Number = the the select record to print.
I'm lost - any ideas welcome.
Cheers