I need some advice here. What is the best way for Access to tell whether an updated record is a new record, or a record that I just edited.
For instance, if I am entering a new order, and after that order updates I will have Access automatically do something with part of the data...however, if I just edited that order, then I don't want Access to do anything.
I have expermented with the OnDirty event, but ity seems to triggered when a record is new or edited.
I know I can just add a field to the Orders table and make it true or something the first time it is created and go from there, but I was thinking there is probably a way that I am not thinking of.
Thanks for any input.
For instance, if I am entering a new order, and after that order updates I will have Access automatically do something with part of the data...however, if I just edited that order, then I don't want Access to do anything.
I have expermented with the OnDirty event, but ity seems to triggered when a record is new or edited.
I know I can just add a field to the Orders table and make it true or something the first time it is created and go from there, but I was thinking there is probably a way that I am not thinking of.
Thanks for any input.