R
Ron Bentley
Hi
I have a form with a combo box that goes to a specific record.
What I want to do is when a filter is applied to the form the combo box only
displays the filtered selection.
the SQL code for the combo box is
SELECT DISTINCTROW [suppliers phone].id, [suppliers phone].Company,
[suppliers phone].Buyer
FROM [suppliers phone]
ORDER BY [suppliers phone].Company;
I,m quite new to Access but "supplier phone" is the table name should I be
pointing my combo box to the form.
Cheers
I have a form with a combo box that goes to a specific record.
What I want to do is when a filter is applied to the form the combo box only
displays the filtered selection.
the SQL code for the combo box is
SELECT DISTINCTROW [suppliers phone].id, [suppliers phone].Company,
[suppliers phone].Buyer
FROM [suppliers phone]
ORDER BY [suppliers phone].Company;
I,m quite new to Access but "supplier phone" is the table name should I be
pointing my combo box to the form.
Cheers