I have a form that, when I'm entering data, uses information from another form.
What I'd like to do is
1. Save the current record (easy enough: just close the form)
2. Close the OTHER form before closing the currently open one, but making sure that the information I'm am getting (e.g. a customer number) gets into the table.
3. Close the current form.
I've done a lot of searching, but I can't seem to find anything.