Next Generation Emulation banner
1 - 2 of 2 Posts

· Registered
Joined
·
11,117 Posts
Discussion Starter · #1 · (Edited)
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:
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'
Code:
Private Sub Report_Activate()
If [Seat ID] = "C" Then
[childsign].Visible = True

End If

End Sub
 

· Registered
Joined
·
643 Posts
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....
 
1 - 2 of 2 Posts
This is an older thread, you may not receive a response, and could be reviving an old thread. Please consider creating a new thread.
Top