I have a combobox that has a rowsource based on two fields, ItemCode and ItemDesc, in respective order. The combobox has its Limit to List property set to No and its bound to ItemCode. Filling up the combobox will fill up other fields such as UnitPrice and UOM.
The problem that I face is when users choose an item in the combobox and ItemCode is appearing in the box. I would want the ItemDesc to appear on the box instead of the ItemCode. Not sure if I have explained this well and so I attached a db for you guys to try it out. Any help will be deeply and greatly appreciated! Thanks to all!
Regards,
Swee
The problem that I face is when users choose an item in the combobox and ItemCode is appearing in the box. I would want the ItemDesc to appear on the box instead of the ItemCode. Not sure if I have explained this well and so I attached a db for you guys to try it out. Any help will be deeply and greatly appreciated! Thanks to all!
Regards,
Swee
Attachments
Last edited: