This will work - but I can't say that it is the most elegant way to achieve this.
1
I created a 'Continuous' Form using Form Wizard and dropped a few fields onto the form.
When I ran the Form - it displayed all records.
2.
In the Form's Property Sheet - Data Tab - Record Source - I put this SQL statement:
SELECT [ID], [Order], [Customer], [No_Of_Boxes], [REASON] FROM [TableName] WHERE [Customer] = [Enter Customer Name];
When I ran the Form I got a prompt saying 'Enter Customer Name'.
When I entered a legitimare Customer Name - the Form showed all records for that Customer.
3.
I added a command Button to the Form Footer section of the Form and put this Code [use Code Builder] in the 'On Click' Event:
Code:
Private Sub Command17_Click()
Me.Requery
End Sub
When I clicked the button - it prompted me for another name . . .
4.
I also added the Me.Requery to the 'On Load' event of the Form.
That way - when I close and then open the Form, even though my last Customer's records were up there - I had the immediate option to enter a new Customer name.
I hope this helps! Let me know if you have questions!
All the best!