P
Piperlynne
I have a form - frmCustomer
that I added a subform frmBrand to to pull up brand information if the
customer name field matches. There can be many brands per customer. I want to
be able to make a combo box of ONLY those brands that pull up.(instead of
using the record navigation 1 of 6 etc)
frmCustomer is based off tblCustomer that has CustomerName as a field
frmBrand (subform) is based off tblBrand that has CustomerName as a field.
The user should be able to select a customer then use the CustomerBrand
dropdown on the subformBrand to select those brands associated with the
customer.
Tell me there's a really easy solution that I'm completely overlooking.
that I added a subform frmBrand to to pull up brand information if the
customer name field matches. There can be many brands per customer. I want to
be able to make a combo box of ONLY those brands that pull up.(instead of
using the record navigation 1 of 6 etc)
frmCustomer is based off tblCustomer that has CustomerName as a field
frmBrand (subform) is based off tblBrand that has CustomerName as a field.
The user should be able to select a customer then use the CustomerBrand
dropdown on the subformBrand to select those brands associated with the
customer.
Tell me there's a really easy solution that I'm completely overlooking.