Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2002
    Posts
    14

    Exclamation Unanswered: Triggering an event when a record is moved off of

    I am trying to automatically fill in a field (based on criteria) for records in datasheet view, but only if they are not manually filled in during record creation.
    I was thinking this would be very easy if I could find a way to make "moving off current record" an event, or something to that effect. Any suggestions would be greatly appreciated. Thanks in advance.

  2. #2
    Join Date
    Jul 2002
    Location
    Romania
    Posts
    122
    If by datasheet you mean the table or query, I'm afraid you can't...
    A workaround would be to create a form based on that table or query and open it in Datasheet view... That way you will have the BeforeInsert, BeforeUpdate, AfterUpdate and AfterInsert events of the form.

    On a second thought, tables (and query output) should not even be available to users in a databasa...

    HTH

Posting Permissions

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