Form won't load in Access 2007

[Ruth]

I have a bound data entry form which works fine in Access 2003 but won't render in Access 2007, and gives the error message that there is a problem with the OnLoad event. The OnLoad event simply sets the focus to the first data entry field:

Private Sub Form_Load()
        Me!Contract_Type.SetFocus
End Sub

Does anyone have a clue why this simple command wouldn't work in Access 2007?

Thanks, Ruth

 

[HiTechCoach]

it may be the event.

try using the on current event.

 

[Ruth]

Would that make a difference between Access 03 and Access 07?

 

[Ruth]

More Information: Form won't load in Access 2007

Here's more information:

It's happening on the two forms that create new records. The "update" forms seem to work fine.

The first form gives me the error "2105 Can't go to the specified record".
The second form gives me the error "2448 You can't assign a value to this object".

Again, this all works fine in earlier version of Access than 2007.
Thanks, Ruth

 

[HiTechCoach]

It's happening on the two forms that create new records. The "update" forms seem to work fine.

If this as true, what makes you think it was the code in the On Load event that is causing the issue? Is there a lot more code than you posted in the On Load event?

 

[SOS]

If you have the tab order set, you shouldn't need to set the focus to a control as the first control in the tab order would be the one the form would start with.

This isn't a subform is it?

 

[Ruth]

I found the problem and it wasn't code related. The user, for some reason, got reset by IT to "read only" status on the network drive where the back-end DB resides. Since this is the only application user in the group working on Win 7/Access 07, I assumed it was an Access version issue.

Thank you everyone for your suggestions. This forum is always a lifesaver.
Ruth