Print only what is True!

B

Bob Vance

In tblRemarks I have a field [OwnerReport Yes/No ], I only want the true
records to Print

Case "Print Remark for Client"
strSQL = "SELECT * FROM tblRemarks WHERE HorseID=" _
& Form_frmHorseInfo.tbHorseID.value & ";"
SrNo.ControlSource = "SrNo"
tbHorseName.Visible = True
SrNo.Visible = True
'Only requires in this case.
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
 
B

Beetle

strSQL = "SELECT * FROM tblRemarks WHERE HorseID=" _
& Form_frmHorseInfo.tbHorseID & " AND OwnerReport = True;"

_________

Sean Bailey
 
B

Bob Vance

Thanks Beetle , BRILLIANT :)

Beetle said:
strSQL = "SELECT * FROM tblRemarks WHERE HorseID=" _
& Form_frmHorseInfo.tbHorseID & " AND OwnerReport = True;"

_________

Sean Bailey

Bob Vance said:
In tblRemarks I have a field [OwnerReport Yes/No ], I only want the true
records to Print

Case "Print Remark for Client"
strSQL = "SELECT * FROM tblRemarks WHERE HorseID=" _
& Form_frmHorseInfo.tbHorseID.value & ";"
SrNo.ControlSource = "SrNo"
tbHorseName.Visible = True
SrNo.Visible = True
'Only requires in this case.
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
Click to expand...
Click to expand...
 

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

Report Case by Dates 1
Slight Change needed to Print case 0

Top