 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / New Users / April 2008values
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. On Apr 21, 5:18 am, Rpettis31 <Rpetti...@discussions.microsoft.com> wrote: > 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 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 > 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. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.