If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
cascading combos form to subform help
Can someone help regarding a combo box on a form filtering the contents of a
combo box on a sub form. I am using Access 2007 and I have tried to modify the sample file “How to synchronize combo boxes” which worked on a single form but I don’t have the knowledge to get it to work with a sub form. I have multiple customers each with multiple products that are specific to each customer. There are 4 tables relevant to my question, tblCustomers with CustID as the primary key and field CustomerName, tblProducts with ProdID as the primary key, field CustID and field Description, tbl OrderByCustomer with OrderID as the primary key and field CustID plus other fields and tblLineDetail with LineDetailID as the primary key, field OrderID ,field Quantity and field Description. I have created a form frmOrderByCustomer which contains a subform frmLineDetail these are linked master to child by OrderID. On the form frmOrderByCustomer is a combo box cboCustomers which uses CustID and CustomerName as its row source and this works perfectly . On the subform frmLineDetail is a combo box cboProducts which uses ProdID, CustID and Description as its row source. What I would like to happen is when I select a company in the cboCustomers then the cboProducts will only display the products applicable to that company. I have gotten close but can’t get it right so I am seeking guidance from someone much more knowledgeable than myself . Please reply to this question in the simplest of terms if possible as I am quite new to Access 2007 and still learning as I go, I am conversant with VBA having used it with Excel several years ago. Hope there is enough information to solve my question. Many thanks in advance Jim Brooks -- Don't put off till tomorrow something you could do today because if you do it today and like it you can do it again tomorrow |
Thread Tools | |
Display Modes | |
|
|