I have a form f_Responses with a combobox cboCustomers for getting customer responses. There are two append queries “q_ClearCustomer” and “q_AppendCustomer” behind the On Click event of btn_GetStore.

Table t_Customer has 50,000 records with 4 columns

|StoreName | Platform | FName | LastName |
| Cus001 | rainbows | Richards | JohnsonR |
| Cus002 | Takestwo | Sameons | SamsondS |
| Col001 | Takestwo | AlleniX | JonneteA |
| Cus001 | rainbows | Raymonds | JohnsonR |
| Cus002 | Takestwo | Sameons | SamsondS |
| Cus001 | rainbows | Rowlands | JohnsonR |
| Cus002 | Takestwo | Solomon | SamsondS |

When I need to process records identified as Cus002 I will select from cboCustomers in f_Responses which will populate txtCustomer. Then clicking btn_GetStore is suppose to populate f_Responses with Cus002 records.

I created an append query with cus002 in the criteria of StoreName. I also have the following StoreName = “Cus002” in f_Customer Property Sheet filter.

Do I have to go back to the append query change this criteria when I need to filter for Cus003 and others?

All assistance would be greatly appreciated.