baffled by trying to assign second value from listbox ...

[bricklebrit]

In a form [orders3] which is primarily controlled from the table [orders].

I have a list box of the table [MailType]:

for instance in the table [MailType] I have the values:

MAILINGMETHOD MAILTYPEPRICE MAILAUTOID
Priority Mail $4.00 1
First Class $2.00 2

I need to update the value [FREIGHTCHARGE] in the table [ORDERS] with the the selected second column value in the listbox which is field [MAILTYPEPRICE] rom the table [MAILTYPE].

How can I assign the second column value of the list box in this form (although the form is controlled by the table [orders] and the list box is controlled by the table [mailtype]?

Thanks in advance for any assistance!

 

[Pat Hartman]

This is one of the most frequently asked questions on this forum.

The RowSource for a combo is a zero based array so when you address the data from the other columns you need to keep that in mind.

Me.FREIGHTCHARGE= Me.YourCombo.Column(1) <--- this is the second column

 

[bricklebrit]

Hi Pat,

Thanks for the quick response and quick fix - it did just the trick!

Thanks again!!