Display image on Switchboard

[upsman via AccessMonster.com]

I have a Switchboard form on which I have been displaying a small picture of
our office in the upper left hand corner. Now we have a branch office and
they would like a picture of their office to display. When the Switchboard
opens,
I have a field that tells me which office I'm dealing with but I just don't
know how to
get the correct picture, of the two, on the form. How can I display the
correct picture depending on which office opens the Switchboard menu?

 

[Guest]

I do something similar on my switchboard. I get the names for the pics I'm
going to display from a table into a recordset.
Here's the lines I use. It will pull the picture from the same directory as
the front end .mdb file.

Dim varMyPath As Variant
varMyPath = Application.CurrentProject.Path
Forms("Switchboard").Controls("Image").Picture = varMyPath & "\" &
rstSponsor.Fields("Sponsors") & "." & rstSponsor.Fields("Image Extension")

You should be able to use something similar.
James