Unload from 1 form to another

[andrewf10]

I have a pop-up search form (frmSearch) which works without a problem.
Behind this I have an Unload macro which populates the underlying main form (say frmForm1) but because I want to use this method and pop-up form on many other underlying forms, I've had to create a search form and unload macro for each because the macro is formname specific. (if you know what I mean!)

Is there any way I can just use the 1 search form to unload onto any underlying form, regardless of its name?

Any help greatly appreciated...

 

[Mile-O]

How do you choose which form to load from the search form? What is the criteria that determines the choice of form?

 

[andrewf10]

OK the specifics are this:

I have a field called 'Family' which is held on frmForm1. This is the field I want to search. Beside this field, a command button opens a pop-up form called frmSearch_Family which runs off a query. This form has a macro mcr_Family_DG which hangs off the 'On Unload' event.
The macro design uses the 'SETVALUE' action, which has 2 boxes that need filling:

Item: [Forms]![frmForm1]![Family]
Expression: [Forms]![frmSearch_Family]![Family]

Note how it's setup to ofload into Form1

So, if I want frmSearch_Family to unload into a different form, I'm having to copy it and rename it (obviously) and create a new macro which will unload into say Form2.

Ideally, I'd like to be able to unload into whatever form is open underneath.

Please help!!
Thanks
Andrew

 

[andrewf10]

Huge thanks to PaddyIrishMan who sent me the fix for this.