Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 08-14-2019, 08:58 AM   #1
sanal
Newly Registered User
 
Join Date: Mar 2018
Posts: 9
Thanks: 8
Thanked 0 Times in 0 Posts
sanal is on a distinguished road
Set records in aform in ascending order

The query is in ascending order of a field. But the form based on the query is not shown in ascending order. I want to show the records in the form in ascending order of the value I entered in a field. Please help.

sanal is offline   Reply With Quote
Old 08-14-2019, 09:05 AM   #2
Gasman
Enthusiastic Amateur
 
Join Date: Sep 2011
Location: Swansea, South Wales,UK
Posts: 3,850
Thanks: 411
Thanked 691 Times in 670 Posts
Gasman has a spectacular aura about Gasman has a spectacular aura about Gasman has a spectacular aura about
Re: Set records in aform in ascending order

Zip enough of your DB to show the problem and upload it.
Specify which form you are talking about.
__________________
Access novice. Sometimes trying to give something back.
Access 2007


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Gasman is offline   Reply With Quote
Old 08-14-2019, 09:10 AM   #3
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 3,631
Thanks: 38
Thanked 885 Times in 868 Posts
theDBguy will become famous soon enough theDBguy will become famous soon enough
Re: Set records in aform in ascending order

Hi. You could also try entering the field name in the Order By property of the form and set the Order By On Load property to Yes.

__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
The Following User Says Thank You to theDBguy For This Useful Post:
sanalsurabhi (08-15-2019)
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Report Ascending order Sri99 Reports 15 01-23-2013 09:38 PM
Ascending Order skydiver Reports 8 01-11-2011 10:20 AM
Ascending Order not complying skydiver Reports 12 12-07-2010 11:25 AM
Ascending order dr223 Crystal Reports 1 06-04-2009 10:23 AM
Ascending order problem Groundrush Forms 5 06-14-2002 02:37 AM




All times are GMT -8. The time now is 01:41 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World