 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / May 2008Will not sort
Forms will not sort by Order by. I have to use the select statement including the ordering for the forms sdata source. Thanks, J. > Forms will not sort by Order by. I have to use the select statement > including the ordering for the forms sdata source. > > Thanks, > J. Not much information here to go on. What exactly is your OrderBy code? Did you set the Form's OrderByOn property to Yes?  SignatureFred Please respond only to this newsgroup. I do not reply to personal e-mail There's no orderby on listed. I know in VBA that when using a filter the filteron needs to be true but I am using form design, not vba. > > Forms will not sort by Order by. I have to use the select statement > > including the ordering for the forms sdata source. [quoted text clipped - 5 lines] > What exactly is your OrderBy code? > Did you set the Form's OrderByOn property to Yes? > There's no orderby on listed. I know in VBA that when using a filter the > filteron needs to be true but I am using form design, not vba. [quoted text clipped - 8 lines] >> What exactly is your OrderBy code? >> Did you set the Form's OrderByOn property to Yes? You MUST set OrderByOn = True. Two ways to do this. 1) You would do this either using code, i.e. Me.OrderBy = [LastName], [FirstName] Me.OrderByOn = True or 2) by opening the form in design view and display the Form's property sheet, Data tab. Enter the OrderBy in the OrderBy property line, i.e. [LastName], [FirstName]. Close and save the form change. Then open the form in Form View. Right click on the form and select Apply Sort/Filter. Your Form data is now sorted according to LastName, FirstName. You would then right-click and select Remove Filter/Sort to go back to the original sort. SignatureFred Please respond only to this newsgroup. I do not reply to personal e-mail the other way I have been using is select table.* order by filename as the data source for the form. From al lthis I think the best way would be to use form_open order by > > There's no orderby on listed. I know in VBA that when using a filter the > > filteron needs to be true but I am using form design, not vba. [quoted text clipped - 28 lines] > You would then right-click and select Remove Filter/Sort to go back to > the original sort. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.