Passing variables to multiple instances of a form

[Evan M]

Hello,

I have coded an purchase ordering routine that will create multiple
instances of a purchase order form that the user is able to fill in and then
print. From the main form that will be generating the purchase order, i have
information such as who the order will be issued to, etc. My issue is,
though the correct number of forms loads, i am unable to pass values to
controls on each of the forms. Could someone help me with some code that
will help me accomplish this?

Any insight would be appreciated!! Thanks!
Evan M
evan AT radiologyonesource DOT com

 

[Sandra Daigle]

Each instance of the form has a form object variable associated with it. You
must refer to the instantiated form via this variable since you can't get to
it via the Forms collection.

For example:

dim frm as form
Set frm = New Form_Customer
frm.Custid=121

 

[Jeff Boyce]

Evan

If I might ask, why would a customer need multiple simultaneous purchase
order forms? Just curious...

Jeff Boyce
<Access MVP>

 

[Evan M]

hello Jeff,

I have a form on which the user has the option of ordering different items
from multiple companies. In our company, each time we order parts from a
supplier, we issue a new PO. If a user wants to order different parts from
more than one company, I want multiple instances of the PO form opened with
basic info filled in automatically. When the user finishes with the top
form, I want he/she to be able to print and close the first PO and the 2nd
be directly below it. Is there a better way you think it should be done??
I'm always open to suggestions.

Evan
evan AT radiologyonesource DOT com

 

[Jeff Boyce]

Evan

Nothing jumps right out... I was curious about a situation that could use
multiple POs.

Jeff Boyce
<Access MVP>

 

[Evan M]

okie dokie
Evan

Evan

Nothing jumps right out... I was curious about a situation that could use
multiple POs.

Jeff Boyce
<Access MVP>