Doing a find and pasting the result in a text box...

[WVZ]

Hi
I hope somebody can help me with the following problem:

I have a dropdown list of numbers (1500) with descriptions that the user must choose. Often more is needed than this. I created a popup window in which the user can do find by form to narrow down his search criteria. I would like the user to simply click on the code in the popup window and select that code (not the record) and paste it in the underlaying dropdown list and close the popup window.

The problem is really with the copy value of this field, instead of copying the whole record. Possibly there are other and more elegant ways of looking up values and returning these in the form.

Many thanks for your assistance.

Werner

 

[FoxProProgrammer]

If your dropdown list is a combo box or list box, you can use the Column property to return the value of a specific column.

Example:

ListBox1.Column(column, row)

The row is optional.

dz