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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Joining a table from a list box in an SQL statement
I found and corrected a number of syntax errors and the code now runs fine. Thanks for your help! strsql = "SELECT [" & Me!Combo & "].[Cost ctr], Grp([" & Me!Combo & "].[Cost ctr],[" & Me!Combo & "].[Cost ele]) AS Description, Sum([" & Me!Combo &...- sogen
- Post #5
- Forum: Microsoft: Access Modules (VBA Coding)
-
Joining a table from a list box in an SQL statement
I am trying to join a table from a list box (Me!Combo) to another table in my SQL statement. I am getting an "Object doesn't support this property or method - error 438" The code works fine without the Join or Where clause. What am I missing? Dim db As Database Dim rst As...- sogen
- Thread
- Replies: 4
- Forum: Microsoft: Access Modules (VBA Coding)
