SQL produces no records as a form's RecordSource, but does as a standalone query.

If you turn the OrderByOn in the property sheet and save and close the form, Compact & Repair and re-open the form, does it work (without your code)?
 
If you turn the OrderByOn in the property sheet and save and close the form, Compact & Repair and re-open the form, does it work (without your code)?

No, it doesn't. I also tried adding a field to OrderBy.
 
Can I see a sample of the problem you are talking about then?
 

Users who are viewing this thread

Back
Top Bottom