Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2014

    Question Unanswered: Autofill a field from one field, or if this is blank, another field.

    Hi all.

    I have an Access 2007 database set up that records the decisions on appeals to an independent appeals board separate from my organisation.

    It works great but the problem is that the pesky clients can make supplementary appeals.

    I have a field that records the determination of the "original appeal", and another that records the "supplementary appeal". What I want is a field that auto-populates a "Final Determination" field. So I want it to auto-fill in the data from the "supplementary appeal", OR, if this is blank, the data from the "Original Appeal".

    Could someone tell me the best way to achieve this, ideally without the need to set up a new table or query.


  2. #2
    Join Date
    Apr 2014
    Provided Answers: 32
    In a form, while on the record, have a button, if the record is valid for FINAL DETERM. they can click
    run a macro to
    append query that uses the current index and copies it with the FINAL DETERM as that field setting.

    INSERT INTO tClients ( ClntID, ClntName, ClntAdd1, sTATUS )
    SELECT tClients.ClntID, tClients.ClntName, tClients.ClntAdd1, "FINAL DETERM" AS Expr1
    FROM tClients
    WHERE (((tClients.ClntID)="123"));

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts