Rob: I like to put the Choose command into an eep and run that on entry to the field. Sometimes it is nice to put a button PICK next to the box which also runs the eep. This requires input to a variable and putting in the form variables: columname = .variable
Jim Blackburn Kodiak Ben Petersen wrote: > > 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 > > > > > >
