Text box events

[Guest]

i have a text box on a access 2003 form. the text box's control source is a
dlookup function.

When the dlookup value changes i want an event to be triggered by cant get
any events to trigger a simple message box. i assume its because im using a
dlookup function.

can anyone offer any advice please?

 

[Arvin Meyer [MVP]]

Add your msgbox statement to the code in the afterupdate event.
--
Arvin Meyer, MCP, MVP
Free MS-Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Marshall Barton]

i have a text box on a access 2003 form. the text box's control source is a
dlookup function.

When the dlookup value changes i want an event to be triggered by cant get
any events to trigger a simple message box. i assume its because im using a
dlookup function.

There is no event that tells you when a calculation is
completed, much less when its value has changed.

The way to work with this kind of situation is to use the
AfterUpdate event of the DLookup's dependent variables (i.e.
its where conditions), where you can assume the value will
be changed. Since you can not determine when the DLookup
has compled and the new value is available in the text box,
it is best to do the DLookup in the VBA proecdure(s?) so you
can use the result for other things.