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

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.
 
K

Kelvin

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
 
T

Thomas Simsion

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
 
K

Kelvin

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
 

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

Top