>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

I would recommend a sortable grid. For example, Re: Adding code to event Thread #1276895 Message #1276900