RE: Form Sorted Combo Box

[Dan Goldberg]

I am not sure what vc is but I would try declaring the variables before you enter the form.   Dan -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Robert Vincent Sent: Friday, October 26, 2001 1:46 PM To: [EMAIL PROTECTED] Subject: Form Sorted Combo Box 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