combo box to drop down list

[G Herman]

I want all 120 combo boxes divided over two forms to behave as if
Me!cboBoxName.dropdown
had been written into the "on Got Focust" event

 

[Tom van Stiphout]

On Sat, 4 Jul 2009 10:58:01 -0700, G Herman <G
(e-mail address removed)> wrote:

You can select them all, and set any property for the group. For
example in the OnGotFocus event you can write:
=DropDown_OnGotFocus()

Then write that function in the form's module:
private function DropDown_OnGotFocus()
ActiveControl.DropDown
end function

-Tom.
Microsoft Access MVP