I want a form to display specific customer order on a subform when select by customer id or customer name in a combo box. In the main form. At present, I can't get data populated on the main form let along the subform. I know this can be done, I checked the northwind sample but just can't see where I have gone wrong. compared datasources property in northwind with mine, not seeing any difference
I created the main form using form wizard from a table which has a unique key, customer name, contact person etc. Then changed the unique key field to combo box, hoping when selected a customer ID, the rest of the data will be automatically displayed. However, keep getting error message saying the control can’t be edited, it is bound autonumber field custID. Then I changed the customerName field to combo box and would select the customername however, the rest of the data are not auto displayed. I changed the rest of the fields enable property to No and still can’t get the data changed. The remain as the first record when the form first open.
Is there a setting which I need to changed to able the fields be displayed with new data ???
I created the main form using form wizard from a table which has a unique key, customer name, contact person etc. Then changed the unique key field to combo box, hoping when selected a customer ID, the rest of the data will be automatically displayed. However, keep getting error message saying the control can’t be edited, it is bound autonumber field custID. Then I changed the customerName field to combo box and would select the customername however, the rest of the data are not auto displayed. I changed the rest of the fields enable property to No and still can’t get the data changed. The remain as the first record when the form first open.
Is there a setting which I need to changed to able the fields be displayed with new data ???
