Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Variable Ole graphics

Status
Not open for further replies.

Peps

Programmer
Feb 11, 2001
140
ES
I have a DB for a video collection, the DB containes a report that produces a complete list: [Position],[Number],
[Title],[No Discs]. My intention is that each record shows the number of small discs instead of a simple number. The problem is that if the first record for the first video has a total of 1 disc, all rest shows only one disc, regardless of the true amount.

If [Discos] = 1 Then
Disc1.Visible = True
Disc2.Visible = False
Disc3.Visible = False
Disc4.Visible = False
Disc5.Visible = False
Disc6.Visible = False
Else
If [Discos] = 2 Then
Disc1.Visible = True
Disc2.Visible = True
Disc3.Visible = False
Disc4.Visible = False
Disc5.Visible = False
Disc6.Visible = False
Else
If [Discos] = 3 Then
Disc1.Visible = True
Disc2.Visible = True
Disc3.Visible = True
Disc4.Visible = False
Disc5.Visible = False
Disc6.Visible = False
End If
End If
End If

While the above works on a form, it worthless on a report.
Does anyone have any ideas?


 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top