I have an Access form with a tab control -- five pages. I have the standard "New" button -- here's the code:
If Me.Dirty Then RunCommand acCmdSaveRecord
DoCmd.GoToRecord , , acNewRec
I never have any problem with this in Access 2000, 2002 or 2003, but 2007 sends the focus to the first control on the third page, instead of the first control on the first page (ctl_clFacilityID). This also happens when I filter the form based on a selection in a search screen.
Any idea what I can look for?