regnewby2465
Member
- Local time
- Today, 03:45
- Joined
- Sep 22, 2015
- Messages
- 58
No, the operator really only needs to see the ID_Activity after it is saved. Where would I put the if Me.Dirty statement, and where would I put the update syntax... I am assuming maybe BeforeUpdate event of form?Do users really need to see ID_Activity before record is saved?
Could save record and then populate field with the ID.
If Me.Dirty Then Me.Dirty = False
or
DoCmd.RunCmd acCmdSaveRecord
Or an UPDATE action after record is committed.
UPDATE ActivityT SET ID_Activity = ID WHERE ID_Activity IS NULL