Slight Change needed to Print case

B

Bob

Help Please with the top case "Print Remark of Horse" I want RemarkID from
tblRemarksAdd to be printed as well
Thanx for any help with this.......Bob

Private Sub Report_Open(Cancel As Integer)
Dim strSQL As String
Select Case Me.OpenArgs
Case "Print Remark of Horse"
strSQL = "SELECT * FROM tblRemarks WHERE HorseID=" _
& Form_frmHorseInfo.tbHorseID.value & ";"
SrNo.ControlSource = "SrNo"
tbHorseName.Visible = True
SrNo.Visible = True
tbDate.Visible = True
lblDate.Visible = True

lblRemarkID.Visible = False
tbRemarkID.Visible = False
tbHorseName.ControlSource = "=[Forms]![frmHorseInfo]![tbNameToDisplay]"
tbRemarks.Visible = False
tbRemarkID.ControlSource = ""
tbHorseName.Visible = True
Case "Print Remarks"
strSQL = "Select * from tblRemarksAdd;"
tbHorseName.Visible = False
SrNo.Visible = False

'15 May 2006, Dnyanada Varude.
'Does not require.
tbDate.Visible = False
lblDate.Visible = False

lblRemarkID.Visible = True
tbRemarkID.Visible = True
tbRemarkID.ControlSource = "RemarkID"
tbRemarks.Visible = True
tbHorseName.Visible = False
End Select
Report_rptPrintRemarks.RecordSource = strSQL
End Sub
 

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

Similar Threads

Print only what is True! 2
Report Case by Dates 1

Top