T
Tony Girgenti
Hello.
Having a problem trying to make combo8 show only the field from records
based on the combo0. Combo0, customer, is selected using a drop down.
Combo8 should only select records for customer in combo0 and display the
distinct sidemarks.
It populates the combo8 but has duplicates.
How do i eliminate the duplicates ?
Combobox-b properties has:
RowSourceType=Table/Query
RowSource =SELECT DISTINCT [PENDING ORDERS].[PENDING ORDERSID],
[PENDING ORDERS].SIDEMARK FROM [PENDING ORDERS] WHERE (([COMPANY
NAME]=Forms![CHF - WIP]!Combo0));
Thanks,
Tony
Having a problem trying to make combo8 show only the field from records
based on the combo0. Combo0, customer, is selected using a drop down.
Combo8 should only select records for customer in combo0 and display the
distinct sidemarks.
It populates the combo8 but has duplicates.
How do i eliminate the duplicates ?
Combobox-b properties has:
RowSourceType=Table/Query
RowSource =SELECT DISTINCT [PENDING ORDERS].[PENDING ORDERSID],
[PENDING ORDERS].SIDEMARK FROM [PENDING ORDERS] WHERE (([COMPANY
NAME]=Forms![CHF - WIP]!Combo0));
Thanks,
Tony