Neils,
Thank you for your suggestion. The method you mention is
completely new to me. I have only recently switched from
Paradox to Access.
In Paradox, this function is built in. In PDox you can
select from a lookup table and the entire row or any
portion can be brought into the subform.
Unfortunately PDox is not SQL friendly, hence the switch
to Access.
I would be interested to see the code that is required for
this. I tried your email but the message was returned as
unrecognized.
Thank you very much for your response.
Thanks,
Jack

>-----Original Message-----
>Hi,
>
>maybe you can use a flexgrig control that you populate
>with data from a recordset. When an user click on a row
an
>event is fired and your code starts.
>
>if you are not sure about putting it together i can sebd
>you some sample code (mailto [email]niels.leeflang@lagard.nl[/email])
>
>niels
>
>>-----Original Message-----
>>I have a subform that is in data view. I will use it to
>>store ITEMID, DESCRIPTION, RATE, QUANTITY, AMOUNT.
>>Is it possible to have a multi column list box so that I
>>can select the ITEMID DESCRIPTION and RATE fields at the
>>same time?
>>I need to make sure that the user can only select the
>>correct rate for each item. Any suggestions would be
>>appreciated.
>>.
>>
>.
>