form's picture

  • Thread starter Thread starter Riddle
  • Start date Start date
R

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
 
First, is it possible?
Click to expand...

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?
Click to expand...

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
 
-----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.
Click to expand...

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
 
-----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
Click to expand...
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!
 
Back
Top