List Values

[Guest]

Hello,

I have a need to lookup for multiple fields in a table and move these
multiple fields
into different columns in a form. Can someone help me?

Ex. I create a list box with select firstname, lastname, empid from emp
I would like to store the firstname, lastname and empid selected in
this list box in various fields on the new form - say empfirstname,
emplastname, empid.

In the ListBox there is option to store only in one field.

I can use the list box query as

select firname + ' ' + lastname + ' ' + empid from emp

but then I will have to descramble. I want to avoid doing this.

Thank you for your help!
-Me

 

[Marshall Barton]

I have a need to lookup for multiple fields in a table and move these
multiple fields
into different columns in a form. Can someone help me?

Ex. I create a list box with select firstname, lastname, empid from emp
I would like to store the firstname, lastname and empid selected in
this list box in various fields on the new form - say empfirstname,
emplastname, empid.

In the ListBox there is option to store only in one field.

I can use the list box query as

select firname + ' ' + lastname + ' ' + empid from emp

but then I will have to descramble. I want to avoid doing this.

You can display the list box fields in other text boxes by
using the Column property. E.g.

=thelistbox.Column(1)