from combo box column to text box 1

[munger]

I have a combo box named "LicenseNumber" that successfully displays from a table named "Trucks" the two fields:

"LicenseNumber" and "Weight"

The user is to click on the proper License number which then appears in the combo box.

The "Weight" is then supposed to appear in a text box called "Tara".

I have been unable to get the "weight" to the text box.

Any ideas?

Michael

 

[fmbpcsup]

in the afterupdate event of the combobox type:

me![tara]=me![licensenumber].column(1)

columns in comboboxes are numbered from 0 so your weight is in column 1 (the second column)

HTH

 

[emzadi]

I have incorporated this code, however it is not working. I have the line:

[txtAcctName] = [AccountNo].Column(1)

and I am being told "Method or data member not found" and the word "Column" is highlighted in debug.

Help? Susan M. Wagner
LAPELS
emzadi1@yahoo.com
susanw@lapels.com

 

[Lightning]

emzadi

More detail please! What isn't working? Does anything happen at all?

Lightning

 

[jfhewitt]

You can display data from a listbox column with the following expression: =[<listoxname>].[column](#), where # is the column number, starting with 0. For example, =[listbox].[column](0) will display the data from the first column of the list.

 

[emzadi]

Cool... it worked... thanks to all... This is what I ended up with:

txtAcctName.Text = Account_No.Value + &quot; &quot; + Account_No.Column(1) + &quot; &quot; + Account_No.Column(2) Susan M. Wagner
LAPELS
emzadi1@yahoo.com
susanw@lapels.com