Data Entry in Table

[austin]

There are four columns in the table:
Contact ID, Contact Date, Comments, and Follow up Date.

Is is possible so that every time a date is entered into the follow up date
column, a new record is started with the corresponding Contact ID and puts
the last follow up date into the Contact Date Column?

thanks

 

[KARL DEWEY]

Got to use a form.

Use After Update property to call a macro. Have macro to check if all
other fields not null then Set Value to not-visible text boxes for the data
to carry to new record. Same macro adds new record and Set Value from
not-visible text boxes to new record fields.

Post back if more explaination is needed.

 

[austin]

thank you

 

[Jamie Collins]

There are four columns in the table:
Contact ID, Contact Date, Comments, and Follow up Date.

Is is possible so that every time a date is entered into the follow up date
column, a new record is started with the corresponding Contact ID and puts
the last follow up date into the Contact Date Column?

Consider always creating a new row (transaction log table) and use a
query to find the "last follow up date" rather than storing it.

Jamie.

--