Too many expressions in ORDER BY Clause

[George Stevenson]

I am getting an error message "Too many expressions in ORDER BY Clause" on
several different macros that I am trying to execute that just open a form
with a Query and display some records. What is odd about this is that I
haven't made any changes to any code or forms. When I execute the
specified Query in the Query tab, they work fine, no error message. The
error message only appears when its in the macro connected with the form.

Can anyone make some suggestions about where to start looking.

 

[John Vinson]

I am getting an error message "Too many expressions in ORDER BY Clause" on
several different macros that I am trying to execute that just open a form
with a Query and display some records. What is odd about this is that I
haven't made any changes to any code or forms. When I execute the
specified Query in the Query tab, they work fine, no error message. The
error message only appears when its in the macro connected with the form.

Can anyone make some suggestions about where to start looking.

Try opening the Form in design view and checking (or blanking out) its
OrderBy property.

Perhaps you could post the text of the Macro - you can see it; we
cannot.

John W. Vinson[MVP]

 

[George Stevenson]

That did the trick, thanks.

I have never changed the Order By property. Does that property get
modified when a query is run against the form from the Macro?

 

[John Vinson]

That did the trick, thanks.

I have never changed the Order By property. Does that property get
modified when a query is run against the form from the Macro?

I don't use Macros, and I'm not certain! I believe it does get changed
if someone opens the form and uses the menu options (or, if it's a
datasheet form, clicks on the column headers) to change the sorting,
and then saves the form.

John W. Vinson[MVP]