Inducing After Update Code.

[gchris53]

Hello,

Any advice on the attached would be greatly appreciated.

I am currently customising someone elses database and have the following problem.

A date is updated on a form, in database 1. This then updates a linked table in database 2.
Database 1 then runs a macro in database 2 and produces output dependant upon the data that is held in the linked table. (ie the date)
I basically use the following sequencing to try and achive this.
1) in the load function on the form I open the date form, which then populates a date field.
Dependant upon the date, various other text fields are then populated. but... they are only populated if a user uses the tab function to tab away from the date control. (any combination of using setfocus or save record to move the control does not induce the after update code, hence various other controls are not updated. but for a user using the tab function.

Question.
How do you programatically induce the after update code.

I have tried copying this code into the diry, change event procedures and this did not work?

Many thanks


Chris

[vijaydiwakar]

Hello,

Any advice on the attached would be greatly appreciated.

I am currently customising someone elses database and have the following problem.

A date is updated on a form, in database 1. This then updates a linked table in database 2.
Database 1 then runs a macro in database 2 and produces output dependant upon the data that is held in the linked table. (ie the date)
I basically use the following sequencing to try and achive this.
1) in the load function on the form I open the date form, which then populates a date field.
Dependant upon the date, various other text fields are then populated. but... they are only populated if a user uses the tab function to tab away from the date control. (any combination of using setfocus or save record to move the control does not induce the after update code, hence various other controls are not updated. but for a user using the tab function.

Question.
How do you programatically induce the after update code.

I have tried copying this code into the diry, change event procedures and this did not work?

Many thanks


Chris

sho ur code