values

[Rpettis31]

I have a combo box that looks up an item from the item master table. The
text book next to it is =ItemNumber.Column(1) which lists the item
description.
I have another text box that should list the cost of the item but it seems
it does not like =ItemNumber.Column(2) as nothing is displayed in the box.

 

[banem2]

I have a combo box that looks up an item from the item master table.  The
text book next to it is =ItemNumber.Column(1) which lists the item
description.
I have another text box that should list the cost of the item but it seems
it does not like =ItemNumber.Column(2) as nothing is displayed in the box.  

Hello,

Make sure combo box has 3 columns, then set ColumnCount = 3,
ColumnWidths = 1;0;0. This will include all 3 fields, but will hide
second and third.

Regards,
Branislav Mihaljev, Microsoft Access MVP

 

[Evi]

Does your combo have 3 columns in its Properties, next to Column Count?
(column 2 is the third column in your combo)
To check what is in each of the columns, temporarily put this code into your
combo box's After Update Event.
MsgBox Me.ItemNumber.Column(2)

Finally, is ItemNumber also the name of a field in the table on which your
form is based? If yes, then you may have to change the combo's name.
Evi