Rob, If you can use Choose rather than a combo box you'll have more control.
Ben Petersen On 26 Oct 2001, at 16:46, Robert Vincent wrote: > 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 > > >
