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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Combo Box Find Record
Yep, yep, yep - you nailed it. The IF statement is right on the money. Thanks for taking the time to teach me.- braith
- Post #8
- Forum: Microsoft: Access Forms
-
Combo Box Find Record
Outstanding. It occurred to me that the combo box auto-fills as the user types in it, so the first concatenation option that you suggested works much better than the two-column format we are using. With your code, the combo box auto-fills both first AND last names when an end user types in the...- braith
- Post #6
- Forum: Microsoft: Access Forms
-
Combo Box Find Record
MajP, Your code works perfectly! In fact, I am amazed at the simplicity of it, and it definitely works better than the wizard-created macro. Your explanation drilled to the heart of the matter much better than the Sybex and SAMS volumes I have. Makes me wonder why previous versions of Access...- braith
- Post #4
- Forum: Microsoft: Access Forms
-
Combo Box Find Record
Hello Access wizards (no pun intended!), Version is Access 2007. Unbelievably, I can't seem to find a solution to this problem. Several sites had good information that seemed to come close, but I couldn't get any of the VBA variations to work. I have a simple find combo box that lists records...- braith
- Thread
- Replies: 8
- Forum: Microsoft: Access Forms
