which evetn to use

[alifyag]

hi,
i have a combo box and a print command button.
i want the print command button to be disabled when nothing is chosen from the combo box however as as soon as somethign is chosen from the combo box, i want the command button to be enabled.
in which event should i do this.
i am working in vba coding in access
thanks

 

[LarryDeLaruelle]

In the form's On Open event disable the command button:

cmdPrint.Enabled = False

In the After Update event of the combo enable the command button:

cmdPrint.Enabled = True

Hope that helps. Larry De Laruelle
ldelaruelle@familychildrenscenter.org