Form On Open event, except not exactly

Tech-Archive recommends: Fix windows errors by optimizing your registry

I have a form with a command button that opens a second form and
populates it with data from the initial form. That part is fine.
What I want to do is use that data in an On Open event (or something)
that will execute *after* the data is loaded by the first procedure.

Specifically, the second form should display an image based on a path
and filename concatenated from the first form's data :
Forms!PhotoData!imgFrame1.Picture = strImagePath

It all works fine using a command button on the second form; but that
requires loading a default image and a manual click to display the
intended image. I want the desired strImagePath image to load
automatically when the form opens.

There's a sequence problem, however. I can't transfer the data to the
second form before opening it (DoCmd.OpenForm "PhotoData"); but I
can't create the strImagePath from that data until after the form is
opened, so I can't create the image path string in an On Open event
procedure.

I know there has to be another way to do this. Suggestions? Anybody
want to make me slap my forehead and say, "D'oh!"?

TIA,
Joe

.

Quantcast