Access Data Base Continuous Form Sort

Mieucher · 01-Jul-2008, 09:21 AM #1

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 · 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 · 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 · 01-Jul-2008, 12:48 PM #4

Sorry I don't understand, can you post copy of thr database?

jimr381 · 08:39 AM

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.

Search
Search in:
Show Threads Show Posts
Advanced Search

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

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)