DLookup is one of the most useful built-in functions in Microsoft Access. With this function, you can lookup a value from a table or query with ease. In most cases, it really makes the developer's job much easier, code simpler and easier to maintain, and to understand. In this video, learn how to use DLookup on forms, reports, VBA, and in queries. Plus, find out two pitfalls that you should watch out for while using this function. Related Videos: Getting Started with MS Access Visual Basic for Applications - VBA Code-Behind and Modules https://www.youtube.com/watch?v=Mbr47ILlrPQ VBA MsgBox - How to use message boxes in MS Access https://www.youtube.com/watch?v=JIdjx9lXUcg How to Use a Do Until Loop in MS Access VBA https://www.youtube.com/watch?v=9jLajlySxiY How to Use Iif in Microsoft Access https://www.youtube.com/watch?v=tGfebrGlnHY How to Use the Replace Function in Microsoft Access https://www.youtube.com/watch?v=R5-gzNq7tgw How to Use Nz in Microsoft Access to Handle Null and Empty Values https://www.youtube.com/watch?v=CR3FmVoRFys Iif, If Then Else, and Select Case in MS Access https://www.youtube.com/watch?v=E5HbVmxHxSQ How to Use DLookup in Microsoft Access You are watching this video now! How to Create and Configure a Custom Pop-Up Form in MS Access https://www.youtube.com/watch?v=jB05uECcNTI For developers looking for a new role, check out and sign up: https://www.toptal.com/qKaO2b/worlds-top-talent Needing to hire technical resources for your project? Get the best: https://www.toptal.com/qKaO2b/worlds-top-talent Want to get access to premium content made just for you and have a chat with me? Find me on Patreon : https://www.patreon.com/mackenziedataengineering Demo of my BZ RDP Cloaker: https://www.patreon.com/posts/how-to-block-rdp-98471703?utm_medium=clipboard_copy&utm_source=copyLink&utm_campaign=postshare_creator&utm_content=join_link Want to work with me 1:1? Contact me today and book your free 20 min consultation! Contact form you can find at http://www.mackenziemackenzie.com/ Follow me on social media: https://www.facebook.com/mackenziedataanalytics https://twitter.com/seamacke https://www.instagram.com/seamacke/ https://www.reddit.com/user/seamacke https://www.linkedin.com/in/psmackenzie/ Get Microsoft Office including Access: https://click.linksynergy.com/fs-bin/click?id=BdGJecFFM8A&offerid=1160033.10004289&type=3&subid=0 Got a YouTube Channel? I use TubeBuddy, it is awesome. Give it a try: https://www.tubebuddy.com/seanmackenziedataengineering https://www.youtube.com/watch?v=ln-Mkb5zstE