Use a form to filter record from append query with changing criteria on a column

[Datament]

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


|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.

[madpiet]

No, instead of manually entering a parameter value in your query, you point at your combobox of the form.

= Forms![f_Responses]![ComboboxName]

[June7]

Cross post https://stackoverflow.com/questions/...orename-column

[Datament]

Many thanks. That worked. I was using a subform and did not reference it, but after referencing the subform it worked.