Re: Message Box

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Rick,
Thanks for the reply.

The code works great untill I click OK.
The original code behind the Command Button on click event "DoCmd.Close" still closes the form losing any data entered.
How can I prevent this from happening?

Regards

John



"John" <johnlee2509@xxxxxxxxxxxxxxx> wrote in message news:E0C7A146-66D0-4560-B8D0-974F374B12FF@xxxxxxxxxxxxxxxx
Hi
On my form "frmExitDate" I have a field called "ExitDate" and a command button called "cmdCloseExitForm" The Field "frmExitDate" needs to be completed if a student has left the college.

When the button "cmdCloseExitForm" is clicked I would like a Message Box to give details about the empty field. i.e. "The Field Exit Date must be completed".

However if the Data entry person has opened this form by accident and the student has not left the College, I obviously need to be able to close the form without completing the field.

Any Help Please

Regards

John



.

Relevant Pages

  • Re: question on file locking
    ... The command here is F_SETLK. ... Using your original code, here is what I see tracing the first instance: ... And, while this process is running, a second instance blocks in fcntl: ... This call returns when the first process terminates. ...
    (comp.unix.programmer)
  • Re: oledb date/time insert command format
    ... a silly mistake on my part.....and has led to me wasting your precious time. ... To protect my original code I replaced tablenames, ... I'm still receiving a syntax error in "insert into" command ...
    (microsoft.public.dotnet.languages.vc)
  • Re: system command ;
    ... command will be almost instantaneous. ... file write completing, due to write caching? ... umount it, the umount will nearly always hesitate while any remaining ... On a RedHat 8 system at work, I managed to completely hose 2 floppies ...
    (comp.os.linux.development.apps)
  • Re: Need help with batch files!
    ... You cannot have wildcards in the path component of a copy command. ... In your original code you never actually said what "it does not work" ... The target machine is the same as the source machine. ...
    (microsoft.public.windows.server.general)
  • Re: Experiencing the Grub Error 17
    ... annoying, as, in order to have it completing the boot, I have to run ... the command ... configfile /grub/grub.conf. ...
    (Fedora)