new form

[Jean-Paul]

Hi,

When I open a form from a pushbutton I get the first form (or however
choosen)

Now, I want to open an new form when I push the putton..
I tried:

DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70

In the onOpen command but that doesn't seem to work

Thanks

 

[Rick Brandt]

Hi,

When I open a form from a pushbutton I get the first form (or however
choosen)

Now, I want to open an new form when I push the putton..
I tried:

DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70

In the onOpen command but that doesn't seem to work

Drop DoMenuItem. That has been deprecated for ages.

Docmd.OpenForm "FormName",,,,acFormAdd