Hello,
I have created a form with 2 comboboxes (Employee_ID & Order_Num) and 1 Subform (sfOrder_Detail ). The way I'm trying to make it work is like this ... you select the Employee in the first CB, then the second CB displays the orders the employee has made (Which it defaults to the first order). The you should be able to select the order number and the order details should be displayed in the subform.
So far both CBs work as stated (by using VB), but if you select an order in the second CB, it doesn't change the subform. Although the subform does display orders and you can change orders by using the nav buttons on the bottom of the form.
Also the Employee CB is bound, but the order CB is unbound. If i change it to bound, i get an error message "Control can't be edited; it's bound to an Autonumber field 'Order_Num' ". Also the Link Maste/Child fields are set to 'Order_Num'.
I am about to put out what little hair i have left! any help would be very appreciated!!!!
I have created a form with 2 comboboxes (Employee_ID & Order_Num) and 1 Subform (sfOrder_Detail ). The way I'm trying to make it work is like this ... you select the Employee in the first CB, then the second CB displays the orders the employee has made (Which it defaults to the first order). The you should be able to select the order number and the order details should be displayed in the subform.
So far both CBs work as stated (by using VB), but if you select an order in the second CB, it doesn't change the subform. Although the subform does display orders and you can change orders by using the nav buttons on the bottom of the form.
Also the Employee CB is bound, but the order CB is unbound. If i change it to bound, i get an error message "Control can't be edited; it's bound to an Autonumber field 'Order_Num' ". Also the Link Maste/Child fields are set to 'Order_Num'.
I am about to put out what little hair i have left! any help would be very appreciated!!!!
Comment