Changing Backgrounds

lskuff

Registered User.
Local time
Today, 07:20
Joined
Aug 10, 2003
Messages
14
This is probably not something that hard, but I have a which is looks different whether one person ran a seminar or another person ran a seminar. The only thing different is the background picture and I just need to know how I can make it change depending on who ran the seminar (a field on the report). Thanks!
 
Not sure how many people you have and if there are many then a SelectCase statement would be better but put simply

Private Sub Report_Open(Cancel As Integer)
If Me.MyField = "JoeBloggs" Then
Me.Picture = "C:\Program Files\Microsoft Office\Office\Bitmaps\Styles\GLOBE.WMF"
Else
Me.Picture = "C:\ something else etc"
End If
End Sub
 
Thanks

Thanks! Worked great
 

Users who are viewing this thread

Back
Top Bottom