none
Data Macro- After Insert RRS feed

  • Question

  • I have a table 

    TransactionID

    MemberID

    Code

    TransactionDate

    BatchNo

    TransactionType

    Amount

    Description

    The scenario is everytime i insert a new record it will create a ValidationNo Using the Columns in my table(Code, TransactionDate and BatchNo)

    Using Before Update is working, but what i want is it will create only After Insert.

    Friday, September 20, 2019 11:19 AM

All replies

  • Using the AfterInsert event won't work because that happens as you move off the current record (the one being inserted).

    1. What is the problem you have with using the BeforeUpdate?
    2. Does the AfterUpdate work for you?

    Bill Mosca
    www.thatlldoit.com
    http://tech.groups.yahoo.com/group/MS_Access_Professionals

    Friday, September 20, 2019 9:21 PM
  • I want to create it only once, is there other way to do it?
    Monday, September 23, 2019 2:12 AM
  • I got it.

    I used IsInsert and Set Field in BeforeChange Data Macro

    Thank you

    Monday, September 23, 2019 2:49 AM