Hello,
I am trying to create a combo box on a form and it wont let me select the fields. The box populates the way I want but cant select any of them. I think the problem stems from the main table which is populated via a linked table that is created as an export from Quickbooks. The form draws the 'Order' information from the linked table query and then connects to the 'Game Part' table/query to get the part attributes. I want to create a combobox that allows our production team to select from a list of 'statuses' as the job progresses thru production. Since I figured the linked table is a one-way street so to speak, I created a table to 'store' the order status as it is entered and a Status table to populate the combobox. Not sure this is the right approach, just instinctual. This is my first post ever so please be gentle. Any and all help is greatly appreciated!
I am trying to create a combo box on a form and it wont let me select the fields. The box populates the way I want but cant select any of them. I think the problem stems from the main table which is populated via a linked table that is created as an export from Quickbooks. The form draws the 'Order' information from the linked table query and then connects to the 'Game Part' table/query to get the part attributes. I want to create a combobox that allows our production team to select from a list of 'statuses' as the job progresses thru production. Since I figured the linked table is a one-way street so to speak, I created a table to 'store' the order status as it is entered and a Status table to populate the combobox. Not sure this is the right approach, just instinctual. This is my first post ever so please be gentle. Any and all help is greatly appreciated!