pop-up lists

[jlc28]

Hi!

I have a form, let's say it's called form1. In one of the fields I have the OnClick set to open another form, form2. This form2 is acting as a list of values for the user to select from. My question is how do I get the information from form2 to be placed in the field of form1 based on the users selection?

I hope that makes sense. Any help would be appreciated.

 

[KenHigg]

Sounds like you should use a combo list box (?)

 

[jlc28]

I would

I would but there are over 4000 records. It's a list of vendors and so the information needs to be accessible from the form.

 

[KenHigg]

I think I'd still use a combo box, but if you must...

When a user is in on the record he wants on the second form, I'd use the double click event in the control to set form1!txtField1 = form2!txtField1

(Make sense?)