Need to Update next Record with Data from a previouse record but different field name

  • Thread starter Thread starter Thomas Simsion
  • Start date Start date
T

Thomas Simsion

I have A main form called assets and a sub form called Service records. On
the service records sub form I have created a hidden calculated text box
which gives me the next service date. By use of the lost focus command I run
the a macro that puts this data into the Field Next service date in the
Underlying Table. However the name on the form Is 'linkFromOtherControl'
When I move the scroll bar I want the Data from Next Service Date
'linkFromOtherControl' to populate the field Service date.
Can you Help.
 
Tom, you've posted the same question several items before. Haven't you
gotten as answer yet? If not respond to this message and I can help.

Kelvin
 
If you can help that will be well appreciated.
Kelvin said:
Tom, you've posted the same question several items before. Haven't you
gotten as answer yet? If not respond to this message and I can help.

Kelvin
Click to expand...
 
Add to the code that puts the date into the table, code to put that same
date as the default value for the Service Date. So that when you go to a
new record, the service date will have the last date calculated. this
default value should stay the next time you open the form too. Will this
work? There are 2 other options we could try.

Kelvin
 
Back
Top