Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
SetFocus to a control as part of event LostFocus
Thanks Traffas for the Solution, and also thanks Tony for considering the BeforeUpdate. I have also considered the points that you broguht up and may change the events to address this, but ofr now the workaround suggestion fr0m Tarrafs is what I was actually after. *Man creates because God...- RayTango
- Post #4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
SetFocus to a control as part of event LostFocus
This is a simple form. Choose Mr. Mrs. or Dr. from combo box then enter name in TEXT box and finally gender M/F? also combo box.The code checks that Male only works for Mr. and Female for Mrs. Dr. can be either, like so... Mr. SMITH Male Mrs. Brown Female Dr. Jones Female (or male as the case...- RayTango
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
