By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,096 Members | 1,355 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,096 IT Pros & Developers. It's quick & easy.

Inducing After Update Code.

P: 1
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
Apr 5 '07 #1
Share this Question
Share on Google+
1 Reply


vijaydiwakar
100+
P: 579
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
Apr 5 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.