Im using the report's Open event to set the report's record source.
I can set the "FROM" and "WHERE" clues, but the "ORDER BY" will be ignored :banghead:
I can set the "FROM" and "WHERE" clues, but the "ORDER BY" will be ignored :banghead:
Code:
Me.RecordSource = "SELECT * " & _
"FROM [MyTable] " & _
"ORDER BY [FieldName]"