I have an edit box that lists 2 columns when the pull down is activated. I would like either to search on the first column
and have the 2nd coumn be used or search on the 2nd column and the first column be used.
Example:
Cursor reps - 2 fields repno & rep name

the edit box has the first column repno and I want to search on rep name
or first column be rep name and I want to search on repno

In any case I want the data found to be repno in the edit box field
or
be able to assign the value in repno to a variable
lcRepno=Thisform.StartRep.Value
even thought the repno is the 2nd column in the edit box.

Thanks