Cant delete OrderBy in data properties

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a subform, with a data source of "qry14MediaSubformDatasource".

This query is ordered by MediaID Descending.

This is all fine and works when you view the subform by itself. But, when
you view it in the parent form, you open properties of the subform, and
Access automatically puts an OrderBy value in the OrderBy property. I don't
want it (the OrderBy value "tblMedia.Date") and no matter what I do I can't
seem to get rid of it. It keeps coming back when I delete it. Ver weird. I
delete it, save the subform, open it up in form view, then design view and
the OrderBy value (tblMedia.Date) is back!!!

Any ideas why this OrderBy value on the Data tab of the subform's property
sheet keeps coming back? It is really messing with me.

Any suggestions appreciated.
 
Please ignore my post. I deleted the subform and created again scratch. All
appears to be good now. Some odd occurance, but has now been fixed.
 
Back
Top