Controls locked on Split Form after Access Update

imagodaniel · #1 (**permalink**) 01-24-12, 09:17

I have a split form in an Access 2007 mdb. It has a combination of bound and unbound controls. I cannot enter into any of the unbound controls until I first enter into one of bound controls.

This behavior goes away when I set the form to Single Form.

This behavior started when I updated to MS Access 12.0.6535.5005 from 12.0.6211.1000. I this was included with Office 2007 SP2.

I first discovered it while running the db on another PC with an updated version of access. When I returned to my own PC the problem went away. The problem returned after I updated my own PC.

How can I enter an unbounded control right after loading the form?

imagodaniel · #2 (**permalink**) 01-25-12, 10:50

txtSerial was the control giving me trouble. This addition "fixed" it. I still don't understand what the issue was.

Code:

Private Sub Form_Load()
Me![txtSerial].SetFocus
End Sub

After I enter information in the field I have to select a bound field or click on the datasheet attached to the split form. I can of course manually reset the focus, but this doesn't seem right.