passing data from a pop-up to a form

  • Thread starter Thread starter Jill
  • Start date Start date
J

Jill

I am trying to write a function to pass a value from a
pop-up form back to a record on a data entry form. I have
a command button on each record of a continuous forms
subform, and when clicked I want the pop-up form to open,
the coding information be found (through 3 nested combo
boxes) and then the resulting code (a number) to be
transfered to the record in which the command button is
clicked. How do you write a routine, which is using
information from a form that is by definition closed
(being pop-up/modal) by the time you need to use it.
I'm sure I can't see the wood from the trees, but i've
been going round in circles all day. (& and it's only a
hobby!)
Many thanks for any pointers
 
Rather than closing the form, hide it until you are done by setting its Visible property
to False. This will let the calling code continue to run and also allow you to access the
values on the form.
 
Back
Top