auto sort table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We abuse Access on a daily basis, but it keeps running right along with us!
My department uses several large tables (like, 365 of them...each 100
records long...on average.)
I know we are not supposed to change data right directly in a table but we
have been doing this for years...probably won't stop now.

Anyway, the records in our tables have 6 fields of data with the headings
of: cc, time, caller, location, incident and camera. The key field is the
time.
Can someone help with a bit of VB that after the user inputs data into the
camera field and hits the enter key, Access will automactically sort the the
records ascending and have the cursor return to the last empty record in the
time field?

Thanks alot for looking into this for me.

Rob
 
You shouldn't work directly with tables. Create a query that returns the
data in the order you want, and use the query.
 
Back
Top