Data Entry in Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
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?
Click to expand...

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.

--
 
Back
Top