I've been stymied over this one awhile ... can't seem to figure out the hangup and wondered if anyone had seen or heard.
First off, Access 2007.
Code on a command button the user click's to exit the form ....
If Len(Nz(Me!txtControl, "")) = 0 Then
MsgBox "You must enter something.", , "Control Error"
Me.txtControl.SetFocus
Else
... do the exiting stuff.
Peculiarities:
- It sets the focus on the NEXT item in the tab order (doesn't matter control placement on screen.)
- Works on 30 other forms but not with two.
- No code difference between a working form and an discrepant form (although the discrepant forms are unbound forms, but I have unbound forms it works with no problems.)
- No form properties difference (stared and compared)
Ideas? Or something else that is cracked out with '07?
-dK
First off, Access 2007.
Code on a command button the user click's to exit the form ....
If Len(Nz(Me!txtControl, "")) = 0 Then
MsgBox "You must enter something.", , "Control Error"
Me.txtControl.SetFocus
Else
... do the exiting stuff.
Peculiarities:
- It sets the focus on the NEXT item in the tab order (doesn't matter control placement on screen.)
- Works on 30 other forms but not with two.
- No code difference between a working form and an discrepant form (although the discrepant forms are unbound forms, but I have unbound forms it works with no problems.)
- No form properties difference (stared and compared)
Ideas? Or something else that is cracked out with '07?
-dK