Form property changes

[VeeFour]

I am trying to set a new background for a form using code:

Forms![frmsite].Picture = "C:\example.jpg"

My first problem is when I exit the database and reload it, it reverts back to the original default, how can I make the change permanent?

Secondly, the code only works when a form is open, how can make the change without the form being open?

Kind Regards

 

[PHV]

You may tru this:
DoCmd.OpenForm "frmsite", acDesign, , , , acHidden
Forms![frmsite].Picture = "C:\example.jpg"
DoCmd.Close acForm, "frmsite", acSaveYes

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[TheAceMan1]

VeeFour . . .

Put your code in the forms [blue]On Open[/blue] event! . . .

See Ya! . . . . . .

 

[VeeFour]

Thanks alot fellas, your help is greatly appreciated