[ozzgx4]

Ok I hope I can explain this properly (I am using visual basic in Microsoft access)
In my database I have to create a bookings ticket report, and in that report there have to be certain information. on the ticket I have to put a 'C' which has to appear on every ticket that is a childs ticket. Now the problem is that I have used this code:

Private Sub Report_Activate()
If [Child/Adult] = "C" Then
[childsign].Visible = True
[Child/Adult].Visible = False
Else
[childsign].Visible = false
End If

End Sub

Now the problem is that the 'C' does appear on the ticket but also the 'A' (for adult) also appears as well, which I don't want.

so does anyone know how I can overcome this problem?



EDIT: I tried it another way where each seat ID for Child are A04 and A18. but now all of the tickets appear with 'C'

Private Sub Report_Activate()
If [Seat ID] = "C" Then
[childsign].Visible = True

End If

End Sub

 

[dreampeppers99]

I guess you can put something like that:

(if [Child/Adult] is a field that keeps the info about what kind of ticke (C or A))

Instead of it:
If [Child/Adult] = "C" Then
[childsign].Visible = True
[Child/Adult].Visible = False
Else
[childsign].Visible = false
End If
This (just create a "new" field on report)

[sign].Value = [Child/Adult]
''I dunno if it is Value or Text....