Access Form: simple question

Dear experts -
I think this is simple, but can't get it to work:
There is no space to squeeze in an invoice number field on a form. Instead, when the user tabs out of the invoice amount field, I put in code in the after update event of the field to invoke a popup where the user can enter the invoice number. This works fine.
However, if the user (intuitively) hits shift-enter (to save) after entering the invoice number, it seems to be simultaneously invoking the popup AND the form before update.
Is there some way to only have the popup appear - i.e., if user tries to save record and invoice number isn't entered, the popup is invoked first?
Thanks!
terpsichoreAsked:
Who is Participating?
 
Dale FyeConnect With a Mentor Commented:
You might be able to use the main forms BeforeUpdate event to check for the invoice.  If the Invoice has not been entered, you could call the popup form, enter the invoice # and enter it into the main form.
0
 
LCCSAMCommented:
What version of MS Access are you using?
I would consider putting the code for the "popup" in the On Lost Focus or On Exit event and see if that works. (On Change may work for you as well)
0
 
terpsichoreAuthor Commented:
simple solution that gets the job done -
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.