J
Jim Brooks
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
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