There's no such thing as a stupid question, but they're the easiest to answer.
JoinTour
Login
 
Tag Cloud
acer black screen boot computer connection crash css dell display driver drivers email error ethernet excel explorer firefox firefox 3 game hard drive internet internet explorer itunes laptop lcd linux malware monitor network networking nvidia outlook outlook 2003 outlook express partition password printer problem router slow software sound trojan usb video virus vista windows windows xp wireless
Business Applications
Search
Search in:
 
Advanced Search
Tech Support Guy Forums > Software & Hardware > Business Applications >
Access Data Base Continuous Form Sort


HELLO AND WELCOME! Before you can post your question, you'll have to register -- it's completely free! Click here to join today! We highly recommend that you print a copy of our Guide for New Members. Enjoy!

Closed Thread
 
Thread Tools
Mieucher's Avatar
Member with 37 posts.
 
Join Date: Jun 2008
Experience: Intermediate
01-Jul-2008, 09:21 AM #1
Access Data Base Continuous Form Sort
How do I get the new record entery to show up at the top of a continuous form? It currently is the last record and I would like it to be at the top.
OBP's Avatar
OBP OBP is offline
Computer Specs
Distinguished Member with 6,560 posts.
 
Join Date: Mar 2005
Location: UK
Experience: An old Basic Programmer
01-Jul-2008, 09:59 AM #2
You do it in the Query.
After entering a new record you need some simple VBA that requeries the form.
If the query is "Sorted" Descending and you close the form and then re-open it you will see the latest record at the top.
Mieucher's Avatar
Member with 37 posts.
 
Join Date: Jun 2008
Experience: Intermediate
01-Jul-2008, 10:05 AM #3
It is not the new entered information I want at the top of the continuous form it is the field where the new entry goes.
OBP's Avatar
OBP OBP is offline
Computer Specs
Distinguished Member with 6,560 posts.
 
Join Date: Mar 2005
Location: UK
Experience: An old Basic Programmer
01-Jul-2008, 12:48 PM #4
Sorry I don't understand, can you post copy of thr database?
jimr381's Avatar
Distinguished Member with 3,622 posts.
 
Join Date: Jul 2007
Location: 1313 Mockingbird Lane
Experience: 1 Child, so not much
01-Jul-2008, 04:57 PM #5
The new record row is typically at the bottom of the table. I think he is wanting it to display as the top row instead of the bottom row.

Last edited by jimr381 : 02-Jul-2008 08:39 AM.
Closed Thread

THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
WELCOME TO TECH SUPPORT GUY! Are you looking for the solution to your computer problem? Join our site today to ask your question -- for free! Our site is run completely by volunteers who help people like you solve computer problems. See our Welcome Guide to get started.



Thread Tools


You Are Using:
Server ID
Advertisements do not imply our endorsement of that product or service.
All times are GMT -4. The time now is 04:38 AM.
Copyright © 1996 - 2008 TechGuy, Inc. All rights reserved.
Powered by vBulletin, Copyright © 2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0
Powered by Cermak Technologies, Inc.