>When a user opens a form and scrolls through a database using an ADODC control, how can I set it so that the next time the user opens the form, it shows the last record they viewed, even if it isnt the last record in that database?

Save the primary key to the registry (using SaveSetting). The next time the user open the form, use the ADO Find method to get to the record (retreived the value using GetSetting).