Hi Guys,
I have a text box control on a form with the AfterUpdate event to update 
the rest of the controls on the form after a user type in a receipt 
number. The after update event will basically access an SQL database table 
using the receipt number entered by user, search records, if found update 
the rest of the controls on the form. Now when I enter a receipt number by 
code from a different form the AfterUpdate event don't fire. I will 
appreciate any help on this issue. 
Thanks

George,

The After_Update event is not automatically fired by code.  You need to
specifically call the After_Update logic.

Rand E Gerald
Database Specialist
Information Services / Operations
Bah=E1'=ED National Office
1233 Central St.
Evanston IL 60201
(xxx) xxx-xxxx

-----Original Message-----
From: georgebiko@h... [mailto:georgebiko@h...]
Sent: Thursday, March 28, 2002 4:59 PM
To: Access
Subject: [access] AfterUpdate event won't run when control is updated 
by
code

Hi Guys,
I have a text box control on a form with the AfterUpdate event to 
update
the rest of the controls on the form after a user type in a receipt
number. The after update event will basically access an SQL database 
table
using the receipt number entered by user, search records, if found 
update
the rest of the controls on the form. Now when I enter a receipt number 
by
code from a different form the AfterUpdate event don't fire. I will
appreciate any help on this issue.
Thanks

From the Visual Basic for Applications help file regarding the AfterUpdate
event:

Changing data in a control by using Visual Basic or a macro containing the
SetValue action doesn't trigger these events for the control. However, if
you then move to another record or save the record, the form's BeforeUpdate
and AfterUpdate events do occur.



|-----Original Message-----
|From: georgebiko@h... [mailto:georgebiko@h...]
|Sent: Thursday, March 28, 2002 10:59 PM
|To: Access
|Subject: [access] AfterUpdate event won't run when control is updated by
|code
|
|
|Hi Guys,
|I have a text box control on a form with the AfterUpdate event to update
|the rest of the controls on the form after a user type in a receipt
|number. The after update event will basically access an SQL database table
|using the receipt number entered by user, search records, if found update
|the rest of the controls on the form. Now when I enter a receipt number by
|code from a different form the AfterUpdate event don't fire. I will
|appreciate any help on this issue.
|Thanks
|