I’m using a local view that is populated from multiple tables as the RecordSource for a 3 column grid. It’s working fine, but I want to allow the user to change the ORDER presented dynamically by clicking on the respective grid header.

I have coded the SQL's ORDER clause by setting it as a ?parameter. I change the parameter, do a requery(), and then a refresh() all in the header click method. I'm bumping into pop-up messages asking what value I want for my parameter.

What general approach should I be using?
Bob