Recent content by sysadmin101

My Sub-form in layout mode has a combo-box for the Product ID. How can I display the other fields from the Products Table for the convenience of the user as he is entering more lines? i.e. user selects code for product, which then appears in the field, but the combo box only retrieves one value...

when the user selects a value from a combo-box, the form displays the ID i.e. the auto-increment serial of the table I read into the combo-box. I would like to be able to display more than this for the user; my first idea is to catch that value and then run an SQL SELECT on the table and...