bind multiple columns from a list box

[Guest]

I'd like to select a record from my list box and store more than one field to multiple fields on my form. Such as: My list box has [PONumber] [Company] [PartNumber] [Destination]. I current have the PONumber bound so it stores that info. Can I click once and also store the PartNumber? Any help on how to do that would be appreciated
Thx

 

[Nikos Yannacopoulos]

Neen,

Use the on Click event of the listbox to run a line of code like:

Me.TxtPartNumber = Me.ListBoxName.Column(2)

where TxtPartNumber is the name of the control on the form where you want to
put the part number, and ListBoxName is the name of your listbox control.
Just change them to the actual names.

HTH,
Nikos

I'd like to select a record from my list box and store more than one field

to multiple fields on my form. Such as: My list box has [PONumber]
[Company] [PartNumber] [Destination]. I current have the PONumber bound so
it stores that info. Can I click once and also store the PartNumber? Any
help on how to do that would be appreciated.

 

[Guest]

perfect fix. Thx much