GotoRecord in mainform after closing Add form

[Guest]

Hi,

I have a form to add a new DVD to my database. Now when I press the 'ADD
DVD' button I want to close the 'add dvd form' form and on the main form I
want to change the current record to the one just added. The main form is
open all the time. Anyone know how to jump to this added record? I tried
serveral ways on the GotoRecord method of VBA but nothing worked so far.

 

[Damon Heron]

From what you are describing, the main form is tied to the list of DVDs.
Why have two other forms at all?
If you have nav buttons or record selectors on the main form, then just add
a new record there. If those are missing, then
you could have a command button with a click event:
docmd.gotorecord acdataform "yourmainformname", acnewrec

Damon