Form Sorted Combo Box

[Robert Vincent]

Here's one for the R> Team...   While in a form, I want the user to be able to pick the sort order of items that appear in a Combo Box.   In an effort to achieve this, I created two radio buttons which will load a variable called SORD with the column name LNAME or EMPNO   I then use the following statement in the Combo Box Properties WHERE CLAUSE dialog box:       ORDER BY &SORD WHERE COMPANY = .VC   This where clause will not work in the form, but does work at the R>   Ideas greatfully accepted on this one!   - Rob Vincent R.A.V. Enterprises Dearborn Heights, MI