linked text boxes

[Dean Collins]

I want to implement 2 text boxes that are linked.
TextBoxA allows date entry and TextBoxB allows integer
entries. Entering a date in the TextBoxA will calculate
the difference in days from 01/09/02 in the TextboxB.
Also changing the integer in TextBoxB will calculate and
change the date in textboxA.

Any Ideas how and coding tips will be much appreciated.

Thanks in advance
Dean Collins

 

[Michel Walsh]

Hi,

Use the AfterUpdate event of each control. While in VB6 the changes made by code fire that event
too (in addition to changes made by the end user), in Access, only the changes made by the end user
fire, explicitly, that event, so there is (less likely) no concern about a after-change-loop to
occur, in Access: in AfterUpdate of TextA, change TextB, and in the AfterUpdate event for TextB,
change TextA.


Hoping it may help,
Vanderghast, Access MVP