Jim Dettman
jimdettman at verizon.net
Sun Feb 2 09:15:23 CST 2014
As Shamil mentioned, you can with a text box class and with events, but it's a lot of work to hook it up. What you can also do is write one procedure that accepts a form and control reference as string arguments, and then with some code set all the afterupdate events in the property sheet to that procedure. I can dig out an example if you want. Jim. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of ACTEBS Sent: Sunday, February 02, 2014 07:14 AM To: accessd at databaseadvisors.com Subject: [AccessD] Multiple Unbound Text Boxes After Update Event Hi Everyone, I have a form that has a sections with 100 separate text boxes that require users input. Once the user inputs values it triggers various calculations to be carried out. My question is, instead of having an After Update event triggered for each text box, which is a lot of code to manage, is it possible to execute the code in some other fashion that applies to these 100 text boxes only, but can be placed in one module? There are other text boxes and combo boxes on this form, but I don't want the code to apply to them. Is this possible? Thanks Vlad -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com