Macro Submit Then Open Form With That Record

[Jamz]

Hi Guys,

Right I have a macro that creates a new record then closes the form back to the main menu.

Now I would like to change this a little, so it creates the new record, then opens another form pointing at the record that has just been created.

So far it runs:

GoToRecord - New
Close Window

But I would like it to
GoToRecord - New
OpenForm (new record that was just created)
Close Window