H
hwzone
hi there, I am creating a project for my company, they want me t
generate two reports from a form,
my form has a field call 'permit no' , the report generated will be al
the permit nos scan in. e.g TT123656, TT126799, GG66562, GG66652 etc
They want two reports, i.e one report for TT... and another one fo
GG... , how can I do that ?
I include a preview button in the form , the code as shown below, wha
should I add in in order to get only the TT or GG report when I clic
on the button. I would be appreciate if someone can help me on this
Thanks
Private Sub CommandReport001_Click()
On Error GoTo Err_CommandReport001_Click
Dim stDocName As String
stDocName = "MUS_T"
DoCmd.OpenReport stDocName, acPreview
Exit_CommandReport001_Click:
Exit Sub
Err_CommandReport001_Click:
MsgBox Err.Description
Resume Exit_CommandReport001_Click
End Su
generate two reports from a form,
my form has a field call 'permit no' , the report generated will be al
the permit nos scan in. e.g TT123656, TT126799, GG66562, GG66652 etc
They want two reports, i.e one report for TT... and another one fo
GG... , how can I do that ?
I include a preview button in the form , the code as shown below, wha
should I add in in order to get only the TT or GG report when I clic
on the button. I would be appreciate if someone can help me on this
Thanks
Private Sub CommandReport001_Click()
On Error GoTo Err_CommandReport001_Click
Dim stDocName As String
stDocName = "MUS_T"
DoCmd.OpenReport stDocName, acPreview
Exit_CommandReport001_Click:
Exit Sub
Err_CommandReport001_Click:
MsgBox Err.Description
Resume Exit_CommandReport001_Click
End Su