Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Error check

Discussion in 'Information Technology' started by RichardT, Nov 14, 2005.

Tags:
  1. RichardT

    RichardT
    Expand Collapse
    Guest

    I have a table with a status field with values of either "OK" or
    "Incomplete". This table sits in a subform. I want to run an update process
    (macro or VBA) on the main form, but I want the process to first check if
    there are any values in the subform that are still set to "Incomplete" - if
    so, then I would like to display an error message and stop processing.

    Any ideas how to do this?

    Thanks
     
  2. Loading...


  3. Van T. Dinh

    Van T. Dinh
    Expand Collapse
    Guest

    I guess you can get the (filtered) Recordset of the Subform and use
    FindFirst (DAO Library required) to see if there is any row/Record in the
    Subform's Recordset that has the value "Incomplete".

    Alternatively, you can use a DCount() with criteria so that selected Records
    are the same with the Records currently on the Subform with an additional
    criterion to select only "Incomplete". If DCount() returns > 0, that means
    Record(s) with "Incomplete" exist.

    --
    HTH
    Van T. Dinh
    MVP (Access)



    "RichardT" <RichardT@discussions.microsoft.com> wrote in message
    news:A41ED028-573B-4787-84D3-E5115F89BEC1@microsoft.com...
    >I have a table with a status field with values of either "OK" or
    > "Incomplete". This table sits in a subform. I want to run an update
    > process
    > (macro or VBA) on the main form, but I want the process to first check if
    > there are any values in the subform that are still set to "Incomplete" -
    > if
    > so, then I would like to display an error message and stop processing.
    >
    > Any ideas how to do this?
    >
    > Thanks
    >
    >
     

Share This Page