View Full Version : Changing Backgrounds


lskuff
01-02-2004, 11:20 AM
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!

Rich
01-02-2004, 01:53 PM
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

lskuff
01-02-2004, 05:28 PM
Thanks! Worked great