This is driving me nuts. Here is what I want to do:
I have a control on a form which is a required text field for data entry. On
the Lost Focus event I placed code to alert the user to enter text if the
field is left null. Also on this form is a button which executes a macro to
exit out of access. But...when in "add record" mode, and I want to end the
application, when I click the exit button to exit access, the first field
loses focus & so kicks off the error message "please enter name" before
exiting the program.
The field (Dr_Grp) is designed to have focus when the user clicks the add
button to add a new record. I want the focus to remain on this field for
usability purposes, but I also want to be able to give the user a user
friendly message for the required field if they tab out of it. Is there a
clever (or not so clever) way to do both without having to move to a previous
record or something before closing out? I understand what is happening, when
I exit the program, the Dr_Grp field loses focus kicking off the message.
I'm fairly new to VB...
Message posted via http://www.yqcomputer.com/