Start position in a table

[djchapple]

I have a database table which is basically a calendar containing 4 columns (i) the date, (ii) special info about that date, (iii) morning volunteers and (iv) afternoon volunteers.

When I go to this table the cursor is positioned at the very first date and i then have to scroll though record after record to get to the current date.

How can I get it to remember the last date used?

I am using Vista and Access 2003

 

[RuralGuy]

If you are talking about a form them maybe this link is what you've been looking for.

 

[djchapple]

Many thanks.

However it seems rather complex to me but I will persevere and give it a try.

 

[RuralGuy]

Post back after you give it a try if you are still having problems.

 

[neileg]

A simpler approach may be to impose a sort order on your data. Sort in descending date order and the most recent date will be first.

 

[djchapple]

I tried entering the data from the MS help Sheet and eventually I was able to save without any error being thrown up.

The database now works correctly in all respects other than the one below.

When I try to view the modified Form in Design View Access crashes so i cannot find any way to view the code and make any changes as necessary.

i am using Vista and Access 2003.

 

[RuralGuy]

Have you already done a Compact and Repair? Have you tried importing all of your db into a fresh, empty db? How about a /decompile?