G
Guest
I am having some trouble with a combo box that is embedded on a subform. The
main form “Customers†has a subform on it called “WebDataSubformâ€. On this
subform is a combo box called “Locationâ€. I want the combo box locations to
be specific to each customer but cannot for the life of me get it to work! I
have another subform on the main cust9omers form that contains the table for
locations. This table displays correctly when you move from one customer to
the next as this table only shows the locations specific for each customer.
If you add a new customer, the table is blank and you can add locations to it
no problem. But the &*^&^ combo box shows the locations for all customers. It
should be blank for a new customer (e.g. a new combo box list). The main form
customers has the field CustomerID. The combo box has the fields LocationID,
LocationName and CustomerID. Any help would certainly save more of my hair
from being pulled out. Thanks.
main form “Customers†has a subform on it called “WebDataSubformâ€. On this
subform is a combo box called “Locationâ€. I want the combo box locations to
be specific to each customer but cannot for the life of me get it to work! I
have another subform on the main cust9omers form that contains the table for
locations. This table displays correctly when you move from one customer to
the next as this table only shows the locations specific for each customer.
If you add a new customer, the table is blank and you can add locations to it
no problem. But the &*^&^ combo box shows the locations for all customers. It
should be blank for a new customer (e.g. a new combo box list). The main form
customers has the field CustomerID. The combo box has the fields LocationID,
LocationName and CustomerID. Any help would certainly save more of my hair
from being pulled out. Thanks.