Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Is it possible to create and event for all controls on a form?

Status
Not open for further replies.

bhujanga

Programmer
Joined
Oct 18, 2007
Messages
181
Location
US
I have a form in which certain calculations need to be done if any one of about 50 fields change. As it is now, I have "After Update" code in there for all of these fields. It would be nice if I could just put code in somewhere that would run if any field on the whole form were updated. Is there somewhere to do this?
 
You might be able to create a single function to be called. Then select all of the text boxes and set their After Update property to the function name.

Duane
Hook'D on Access
MS Access MVP
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top