Dear All,
I have an Order-Product scenario in which I want to display order details and in a sub-form the product details of the items in the order. That works fine and it is quite easy to set-up in Access 2013!
Now I want to change the display of the product name's attribute so that it will be a combo-box rather than a textbox. I can get the combo-box to show but I would like it to default to the item that is the product name; at the moment if the Product table has product1 and product2 as product names and I am looking at an order that contains product2, product2 will not automatically be the value of the combo-box but it will be empty, product1 and product2 (i.e. all the values from the Product table).
Is there a way I can get the value to be the name of the particular product in the particular order?
Regards,
George
I have an Order-Product scenario in which I want to display order details and in a sub-form the product details of the items in the order. That works fine and it is quite easy to set-up in Access 2013!
Now I want to change the display of the product name's attribute so that it will be a combo-box rather than a textbox. I can get the combo-box to show but I would like it to default to the item that is the product name; at the moment if the Product table has product1 and product2 as product names and I am looking at an order that contains product2, product2 will not automatically be the value of the combo-box but it will be empty, product1 and product2 (i.e. all the values from the Product table).
Is there a way I can get the value to be the name of the particular product in the particular order?
Regards,
George