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 & "'")
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 & "'")
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
Yes ! It was that simple ! Thank you all ! What an awesome forum. I hope I can be helpful at some point :-)