R
Rhonda Fischer
Hello,
I have a continuous form based on my Deliveries Table;
containing the fields: supplierID, customerID, date, qty.
I have a combo list of Suppliers which is to determine
the list of Customers displayed in a combo box on the
same line. For the first entry all works as intended the
user selects a Supplier and then a Customer based on this
supplier. However for subsequent entries the list of
Customers is still based on the very first Supplier
selected on the line above.
Following are the property values of the two combo
boxes. Do I need to somehow set the focus on the last
selected cboSupplierName or call an event from it's
lost focus routine to somehow refresh?
Any ideas would be terrific.
Thank you very much.
Rhonda
cboSupplierName:
===============
Control Source: SupplierID
Row Source: qryListSuppliers
SELECT DISTINCT [tblSupplier].
[supplierName], [tblSupplier].[ID]
FROM tblSupplier
ORDER BY [tblSupplier].[supplierName];
Column Bound: 2
Column Widths: 1cm;0cm
cboCustomerName:
===============
Control Source: CustomerID
Row Source: qryCustomerForSupplierSelected
SELECT tblCustomer.customerName,
tblCustomer.ID
FROM (tblSupplierCustomer INNER JOIN tblSupplier ON
tblSupplierCustomer.supplierID = tblSupplier.ID) INNER
JOIN tblCustomer ON tblSupplierCustomer.customerID =
tblCustomer.ID
WHERE (((tblSupplier.ID)=[Forms]![frmDeliveries]!
[cboSupplierName]))
ORDER BY tblCustomer.customerName;
Column Bound: 2
Column Widths: 1cm;0cm
I have a continuous form based on my Deliveries Table;
containing the fields: supplierID, customerID, date, qty.
I have a combo list of Suppliers which is to determine
the list of Customers displayed in a combo box on the
same line. For the first entry all works as intended the
user selects a Supplier and then a Customer based on this
supplier. However for subsequent entries the list of
Customers is still based on the very first Supplier
selected on the line above.
Following are the property values of the two combo
boxes. Do I need to somehow set the focus on the last
selected cboSupplierName or call an event from it's
lost focus routine to somehow refresh?
Any ideas would be terrific.
Thank you very much.
Rhonda
cboSupplierName:
===============
Control Source: SupplierID
Row Source: qryListSuppliers
SELECT DISTINCT [tblSupplier].
[supplierName], [tblSupplier].[ID]
FROM tblSupplier
ORDER BY [tblSupplier].[supplierName];
Column Bound: 2
Column Widths: 1cm;0cm
cboCustomerName:
===============
Control Source: CustomerID
Row Source: qryCustomerForSupplierSelected
SELECT tblCustomer.customerName,
tblCustomer.ID
FROM (tblSupplierCustomer INNER JOIN tblSupplier ON
tblSupplierCustomer.supplierID = tblSupplier.ID) INNER
JOIN tblCustomer ON tblSupplierCustomer.customerID =
tblCustomer.ID
WHERE (((tblSupplier.ID)=[Forms]![frmDeliveries]!
[cboSupplierName]))
ORDER BY tblCustomer.customerName;
Column Bound: 2
Column Widths: 1cm;0cm