populating a form based on another form

[klp via AccessMonster.com]

I have a sales order entry screen. Currently when a CSR is entering in a new
order they will click on the new button. They then can either select the
customer from the drop down list or click on the button next to the drop down
to add the customer(this is the customer entry screen). Once they enter in
the new customer they save and close the form. Then they will be back into
the order entry screen and they will have to select the customer they just
entered. What I would like is to be able to open up the customer entry form,
if it's a new customer or pre-existing, find that customer and be able to
click a select button to populate the order entry screen. Is this possible?

Any help appreciated.

Kim P

 

[Michel Walsh]

Sure, you can push the values in the other form:


FORMS!OtherFormName!Control1 = valueToPushThere
FORMS!OtherFormName!Control2 = OtherValue


that code can be writen in the Close event of the "clients name" form, just
a moment before it get dismissed, or as it may be more appropriate. NOTE: be
sure the OtherFormName is on a NEW record, else, you would be modifying an
existing record!


Hoping it may help,
Vanderghast, Access MVP