Let me just say this:  Your lessons have literally shook my foundations in Access 2003 and have really opened my eyes to a whole lot of new and exciting Access Features.

Anyway, wanted to know if there is a simple way to open a new record in a form, automatically, from a Main Menu button?  I'm trying to figure out not to land on a record that's already been filled out.   Is it covered in the expert/advanced lessons? If so, which one?

Thanks

---

Reply from Alex Hedley:

Macro
1) open form
2) GoToRecord (Record: New)

VBA
DoCmd.OpenForm "FormF"
DoCmd.GoToRecord acDataForm, "FormF", acNewRec

Or

DoCmd.OpenForm "FormF",,,,acFormAdd