Simple Login

[hfsitumo2001]

Hi.. Anyone can help me why my simple login can not work, I think all the VBA on Click event is already correct.

In my actual login form also I have a welcome scrolling label. Will it hinder the Set Focus, and can not close the form?

 

[June7]

Code does not have combobox name correct. Should be ComboBoxUserSelect not ComboUserSelect. Precede controls with form reference or its Me shortcut to discover errors like that: Me.ComboBoxUserSelect.

Also misspelling of LoginForm it shows LoginFrom. So that's why doesn't close.

It is not necessary to type .Value property because it is default for data controls.

 

[arnelgp]

agree to use Me., so you get the List of properties/method.

 

[hfsitumo2001]

Code does not have combobox name correct. Should be ComboBoxUserSelect not ComboUserSelect. Precede controls with form reference or its Me shortcut to discover errors like that: Me.ComboBoxUserSelect.

Also misspelling of LoginForm it shows LoginFrom. So that's why doesn't close.

It is not necessary to type .Value property because it is default for data controls.

thank you June

 

[hfsitumo2001]

agree to use Me., so you get the List of properties/method.

Arnel, I have ck the difference in your code, but what is the advantage of using Me.ComboBoxUserSelect.ListIndex