Need some Combobox and Subform help PPPlease!!

[chester64]

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!!!!

[NeoPa]

Have a look at Example Filtering on a Form or Cascading Combo/List Boxes for fuller help on this.

Essentially I would ensure both CBs are unbound. When an order is selected the form in the subform needs to be filtered to reflect the order selected.

Does that help?

Welcome to Bytes!