Hi,
I have a continous form that displays Name and Address of Suppliers.
In the form there is a combo box for 'Active Address' and 10 other text boxes. All the fields coem from one table, "Primary Suppliers".
The combobox is for 'Active Address' with values 'Yes' and 'No'.Control source of the form is,
Select * from PrimarySuppliers where [ActiveSupplier]="Yes". I want the form to display only the Suppliers who has 'Active address' = "Yes".If user selects "No" in the combobox for a supplier I want the form to refresh and not show that particular supplier record in the continous form.
Please treat this as urgent and help me solve this.
Thanks