how to change form background picture using VBA Code

[v5652]

i want to change the form background picture through VBA code. because if path of the mdb file changed then i have to change path of every form background picture.
all background pictures are linked.
can anyone pl help...?

 

[PHV]

Have a look at the Picture property of the Form object.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[TheAceMan1]

How are ya v5652 . . .

A [blue]static file location[/blue] for these files is what you need, and the [blue]location should be local to the machine![/blue] Local affords faster loading and no traffic interference if the db resides on a network.

A path as simple as C:\dbPics\ is all it takes.

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[v5652]

thanks to both of u for the quick response.