Checking ALL fields for missing values

Tech-Archive recommends: Fix windows errors by optimizing your registry

I would like an Error Message to display the names of the Fields missing data
entry BEFORE the a macro to open the next form is intiated. The forms are
mostly point n click in option groups. I want to make sure the person
entering data did not miss any fields before clicking the macro to open the
next form. If they do miss a field, I want the name of the field displayed
and the focus of the cursor set back to the missing item. I'm relatively new
to VBA code, so if there is an easy code that anyone knows..it would be
helpful Thanks.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200801/1

.

Relevant Pages

  • Re: Is it possible to prevent error message displays?
    ... I just tried that code and the error message still displays. ... "Tom Ogilvy" wrote: ... displayed before the macro runs - but you tell us. ... messages you intend to display elsewhere. ...
    (microsoft.public.excel.programming)
  • Combo box - error message
    ... I have a combo box - I want to display an error message when the item entered ... I created an msgbox macro to display the text that will display. ... Pat ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Combo box - error message
    ... the combo box's LimitToList property to Yes - or the NotInList event will ... > I created an msgbox macro to display the text that will display. ... > In the Combo box properties list, I placed the macro name in the "on Not ... > not in the combo box list, it gives me no error message. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Use First Line as File Name and Save Each Page As a Seperate File
    ... displayed in the top border until the file is saved. ... What happens if you run a macro containing that command on another ... back in Lotus 1-2-3 it used to display each step the macro was executing. ... > Does it save OK or give you the same error message? ...
    (microsoft.public.word.vba.beginners)
  • Re: Word document doing a disappearing act
    ... we run a macro I ... past couple of weeks) the log file just disappears, ... instead, Word displays its own error message, asking to reconnect to ...
    (microsoft.public.word.vba.general)