Focus â Some times blurring to me!

March 22nd, 2009, 02:29 PM

Hello Friends. I am Prabha Karan from Thanjavur (South India). I am currently working in a Retail Management Tool using Ms-Access. I created a form for invoice which has 1 tab control having three pages in it. I invoke the âon-exitâ event for every last object (textbox) in a page to set focus on the first control on the next page. For the first two pages its works fine. I want to close the form after exiting (invoking the âon-exitâ event) the last control (text box) on that tab. I used the âDocmdâ command object to the close the form, but it says âThis action canât be carried out while processing a form or report eventâ. Is there a way to do it invoking the âon-exitâ event? Primarily my task is to close the form after getting exit from the last control in tab. To the close the form automatically is my task, if it is not possible using the âon-exitâ event, kindly, explain why this is not happening in this way? If possible, tell me an alternate. Thanks in Advance.

mmcdonal · March 23rd, 2009, 08:07 AM

Hi,

The On Exit event does not close the form, it only fires when the form is closing. Is there a save event or some other data processing that is going on at the last text box? You could use the On Lost Focus event of the last text box and put:

Code:

Private Sub SampleText_LostFocus()
   DoCmd.Close , , acSaveYes
End Sub

Can you post the code you are using? Did you use the Tab Order to move focus from one page to the next, or some other?