form's picture

[Riddle]

First, is it possible?
And if so, how do I have a form change it's background
picture based on a selection in a Combo Box?

Thanks

 

[Larry Linson]

First, is it possible?

Yes, specify the fully-qualified path and filename of a picture in the
Picture property of the Form.

And if so, how do I have a form
change it's background
picture based on a selection in a Combo Box?

In the After_Update event of the ComboBox, set the Picture property of the
Form to a different path and filename.

Larry Linson
Microsoft Access MVP

 

[Guest]

-----Original Message-----


Yes, specify the fully-qualified path and filename of a picture in the
Picture property of the Form.


In the After_Update event of the ComboBox, set the Picture property of the
Form to a different path and filename.

Could you please tell me what the code should look like
that I would write in the After_Update event of the
Combobox to set the picture property of the form based
on a choice in the combobox.
I'm a novice with code.
Thanks

 

[Guest]

-----Original Message-----


Could you please tell me what the code should look like
that I would write in the After_Update event of the
Combobox to set the picture property of the form based
on a choice in the combobox.
I'm a novice with code.
Thanks

Nevermind, I guess I'm not as dumb as I thought.
I set the Form's OnCurrent to an Event Procedure
with the following code:
' if termed status -change background picture
If Me!Combo116 = "3" Then
Me.Picture = "G:\Revenue\Provider\septemberrose.bmp"
Else
Me.Picture = "G:\Revenue\Provider\emerald.bmp"

End If
In my original post I left out details about how
the form is used.
Thanks for pointing me in the right direction and
have a great day!