Passing Data from One Form to Another, Variation on a Theme

[Amy E. Baggott]

I have a form to track changes in sq.ft. that an exhibitor is using.
Previously, it had been called from the orders form and was used only to
track cancellation square footage. Now my boss would like to use it to track
changes in space when an exibitor changes booths. The easiest way to do that
would be to call it from the assignments form at the time the new booth is
assigned. This means that my current way of getting certain data into the
form by using default values will not work properly. Is there a way to have
each form pass the master ID and Show ID to this tracking form when the event
that calls the form is triggered?

 

[Ken Snell \(MVP\)]

Check out OpenArgs argument for the DoCmd.OpenForm action. You can build a
delimited string that contains the two values, and then parse out those
values in the opened form's Load event and assign those values to the
correct places in the newly opened form.