By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,134 Members | 1,918 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,134 IT Pros & Developers. It's quick & easy.

Field 'Ascending' problems in Forms

P: 2
MS Access 2002, in Windows XP.

Hello all, could you please have a look at this problem description?
I have a Query that shows in 'Design view' two fields in which the "Ascending" option is selected.
When opening the Query it shows exactly these selections, and both field are running ascending, so till now no problem.
Out of this Query I have a Form attached which shows one Field as in the linked query (so ascending) but the second Field does not show the ascending sequence

Most probably I missed something in the Field properties when running the Forms 'design view' or is this a bug?

Thanks in advance!!
Aug 15 '08 #1
Share this Question
Share on Google+
2 Replies


P: 23
Open your Form in Design View. Display the Form's Property Sheet. Put the Field Names in the Order By Property like the example given below:

Employees.FirstName,Employees.LastName

Employees is equal to your Query Name.

Copy the following code into the Form Module and save it.
Expand|Select|Wrap|Line Numbers
  1. Private Sub Form_Load()
  2.    Me.OrderByOn = True
  3. End Sub
a.p.r. pillai
** Link Removed **
Aug 15 '08 #2

P: 2
Thanks aprpillai, problem solved!
Aug 18 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.