Returning data to a control

[Dave_cha]

I have a popup form (FRM1) which contains a list of names.

When I access FRM1 from another form (FRM2) I double click on the list box and the selected name is returned to a field/control on FRM2. That bit is easy as I just use "[Forms]![FRM2]![Control name]=[Listbox]" on the popup form.

I now need to be able to populate more than one 'Name' field on FRM2. Beside each control I've created a button which opens FRM1. The problem is, how do I declare the control to which I want to return the name to? I don't want to create a list box for every control I want to fill.

Anyone got any ideas?

Thanks, Dave

 

[Dave_cha]

Tony, I've attached a db which illustrates what I'm trying to achieve.

Thanks, Dave

 

[Dave_cha]

Sorry Tony.
Try this one.

 

[IMO]

How many text boxes do you need to fill from the popup?

IMO

 

[Dave_cha]

At the moment 4.....each one requiring a different name. I'm hoping to get a flexible solution as this number may change.

Thanks, Dave

 

[Mile-O]

I have a popup form (FRM1) which contains a list of names.

When I access FRM1 from another form (FRM2) I double click on the list box and the selected name is returned to a field/control on FRM2.

To do it for multiple forms:

Open FRM1 and send the name of the calling form as the OpenArgs.

When sending the value back to the calling form, evaluate the OpenArgs.

Simple.

 

[Mile-O]

Just in case that made no sense to you, here:

 

[Dave_cha]

Thanks guys,

Really appreciate the help.

Dave

 

[Mile-O]

Double Post