My experience with Access 2007 indicates that occasionally it has a mind of its own and things suddenly stop working like they are supposed to even when they have been working fine for months. You may have to go back and rewrite the code even it ends up looking exactly like what you wrote before. Sorry to be so discouraging!
I hope that someone who is more of a "computer geek" than I am has a better answer. Barbara Mann From: [email protected] [mailto:[email protected]] On Behalf Of kenaf42 Sent: Thursday, May 13, 2010 4:10 PM To: [email protected] Subject: [ms_access] Condition navigating between Controls I have a form in access 2007, with several controls. I used the On Exit Event Procedure for navigating among controls. Example: If Method of Payment = "Check" Then Check No.Set Focus End If If Method of Payment = "Credit Card" Then Credit Card Name.Set Focus End If End Sub And so on for all controls. Form functioned well for months, however today went wild. Navigation order does not execute Event Procedure it follows exactly the order of TAB ORDER DIALOG BOX. Please advice [Non-text portions of this message have been removed]
