Assigning control names to variables

T

Terboy

Hi, I'm trying to write a function that alters the properties of about 25
combo boxes, i.e. the lookup info stored in a table, based on the value in
another combo box. In order to save me writing code for each combo box I'm
writing the function to take the control name when the Gotfocus event is
triggered and change the properties (rowsource, column settings, etc) of the
combo box bu assigning the control name to a variable. Am I going about this
the right way? And if so how do I do it?

Thanks.
 
Top