bind multiple columns from a list box

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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

neen said:
I'd like to select a record from my list box and store more than one field
Click to expand...
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.
 
Back
Top