I de-bugged and the error is in this line. Not sure what it is exactly. Apparently, my code skills are rusty as well: Me.txtZipCode = DLookup("Zip Code", "Counties by State", "State='" & cboState & "' AND County = '" & cboCounty & "'")
Advanced Beginner
Windows 10 
Office 365
I de-bugged and the error is in this line. Not sure what it is exactly. Apparently, my code skills are rusty as well: Me.txtZipCode = DLookup("Zip Code", "Counties by State", "State='" & cboState & "' AND County = '" & cboCounty & "'")
VIP
Windows 10 Access 2007
If you have to have objects with spaces in the names, not recommended ever !!, then enclose them with [ & ]
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
Advanced Beginner
Windows 10 Office 365
Yes ! It was that simple ! Thank you all ! What an awesome forum. I hope I can be helpful at some point :-)
Limiting and Filling Fields based on Another Field
Lists in subsequent records updating based on selection in first record upon re-open.
Form based on query limiting size of a memo field
Posting Permissions
Reply With Quote