Where can I put this choice of recordsource for a form?

[Hey]

Hi All,

I've got a form (frmClient) based on a query (qryClientByName).

I have another query, qryClientByNumber, that has the identical info and is
in numerical order by a client number (assigned at first insert...not the
clientID though).

I want to have the form loaded in either name or number order based on a
check box (chkClientByNumber) on an invisible form that's always loaded.

IF/ELSE statement? IIf statement? Other type? Where would that statement
go, on frmClient form? Where on that form? If not there, where else?

TIA,
me