> 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.
[quoted text clipped - 21 lines]
> TIA,
> Joe
I am far from expert, but it seems you could pass the path with
"openargs' method. in what ever statement you are using to open second
form. Hope this helps
So create a module, and in it, define some PUBLIC variables in which to store
values during the On Open event. Then, at a point of your choosing, simply
call a private (or public for that matter) sub, and use those variables to
fetch what you need.
> 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.
[quoted text clipped - 21 lines]
> TIA,
> Joe
BRC - 28 Jun 2007 21:05 GMT
Sorry about my earlier post, i didn't read your original close enough.
I think what you want to do could be done if you put your code in
form2's activate event. See vb help for details on when it occurrs.
rb608 - 28 Jun 2007 21:58 GMT
> So create a module, and in it, define some PUBLIC variables in which to store
> values during the On Open event. Then, at a point of your choosing, simply
> call a private (or public for that matter) sub, and use those variables to
> fetch what you need.
I sort of took a blunt instriument approach along those same lines. I
just put a duplicate subroutine in the procedure that opens the form
so that it forces the filename into the control as part of opening the
form.
Tx.