Wish to automatically update a field each time a new record is created.

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy previous record into form field 0
Wish to update field each time a new record is created 0
Wish to update a field when a new record is created. 1
Need a Text box in a form to access a field in another table 0
Create custom autonumber field 5
Data Entry Form and Auto Number ID 2
Primary Key new field 2
Updateing a record with a Null value field, fails? 5

Top