VBA to Navigate form

[asmith]

Hey guys,



I think i have an easy one for you today. I have a form that has a combobox that i use to navigate / add new records to the form. I have the combo box working well now so that it adds records the way i want and requeries automatically. What i'm trying to do is add a piece of code so that after the form requeries that it navigates to the new record. I have the records indexed so that the last record using the navigation arrows at the bottom of the form is always the newly created record.

Does anyone know the code used to navigate to the last record? Even if you had the code to navigate to any record i can find the record number using a dlookup.

Thanks
Andrew

[pbaldy]

Does this work for you?

http://www.baldyweb.com/Requery.htm

If not, you could probably use GoToRecord with acLast.

[asmith]

Hi Paul,

The provided example didn't work in my situation but the gotorecord worked beautifully. For others, the code is as follows:

DoCmd.GoToRecord acDataForm, "Input Form", acLast

Thanks
Andrew

[pbaldy]

Happy to help Andrew.