Some form help

[benkingery]

I have a form that opens up when you double click a button on another form. The purpose of opening the form is that the form that opens is intended to act as a selection form. The idea is you find the record on the form that pops up, double click on the value you choose and two things happen:

1) The value you double clicked on gets written back to the original form in a specified field
2) The form that popped up closes.

I can figure out # 2 easy enough. anyone have any ideas on #1?

Thanks

 

[pbaldy]

Please don't post the same question twice:

http://www.access-programmers.co.uk/forums/showthread.php?t=174846

 

[benkingery]

Thanks for the update. Wasn't aware there was a VBA section until after I posted in the forms section. i thought the question was better suited to a VBA discussion than anything.

Thanks for your help.