Re: Assigning control names to variables

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Me.Controls("NameOfControl")

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"Terboy" <Terboy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:6912F896-4A6C-4482-8CA9-4A9988F034BE@xxxxxxxxxxxxxxxx
> 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.


.

Quantcast