HELP!

Not sure if there is a possible solution for this one but here goes.....

I have a form which is used for creating/editing invoices. The first control that gains the focus is a text box for the invoice number. The user has the option to enter an existing invoice number or press one of two buttons by the side of it ([New Invoice] and [Find Invoice]). There are an assortment of other controls on the form for the invoice details.

All Fine So Far.

The problem that I have is that I use the Validate event of the Invoice Number Text Box to check whether or not the invoice number entered is valid. I do not want the user to move to any of the other controls unless a valid invoice number is entered except for the Find Invoice and New Invoice Buttons. Within the Validate event I need to know which control the focus is trying to move to. The form ActiveControl property is still pointing to the invoice number text box as the focus does not move until after the Validate event completes.


Any Ideas?