Wish to update a field when a new record is created.

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

I wish to automatically update a field each time a new
record is created. More specifically, when a new record
is created, and a autonumber ID is applied, I wish to
update the cell of another field (PhotoName) in that same
record.

This is the expression I used to populate the
field 'Photoname' in the first place:

"D:\chris\CORES\photos\16.jpg" & [PhotoID] & ".jpg"
(Where 'PhotoID' is the autonumber field)

Can I modify this expression and use it to update the
record each time a new record is created?

Many thanks for the help, as always!
Chris
 
Back
Top