Arthur Fuller
artful at rogers.com
Sun Mar 7 00:53:53 CST 2004
I have a function called aaNotInList() which takes the same parms as the NotInList function and adds two new ones -- the name of the form to open when adding an item, and the "human" name of said entity, the latter just to pretty up the messagebox that comes up. The functon asks if you want to add a new "XXX" (4th parm) and if so opens the specified form, which uses the typical code to hide itself on OK and close itself on Cancel. Then the function does the usual "add to list and accept the value" and closes the form. It works great but I still have to type in that line of code every time I need one. Not that one line of code is a major hassle, I guess, but can you think of a class-based way to do this? It might be more fun to do it that way. Arthur -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John W. Colby Sent: Saturday, March 06, 2004 1:24 PM To: AccessD Subject: [AccessD] Your favorite control behavior I am taking suggestions for control behaviors that you have found useful and have programmed controls to perform in the past. For example I program the back color of combos, lists and text boxes to change to a given color as they get the focus, and back to their original color as they lose the focus. This helps to avoid the "where's the cursor" questions. Another example, I program the double-click of a combo to open a form to allow editing the data in the table that the combo pulls from. In addition, if a combo is programmed to perform this behavior, I dynamically set its label's back color to a specific color. this is a visual cue that "this combo has the dbl-click behavior activated" What kinds of things do you have your controls do? John W. Colby www.ColbyConsulting.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com