not sure what you're trying to do but....
sql="SELECT *FROM [ASSET] WHERE Item = "'CmbItem.text'"
should be
sql="SELECT * FROM [ASSET] WHERE Item = '" & CmbItem.text & "'"
Note the single quote and double quotes, plus the & is missing
Not sure if that was a typo or the problem with the sql statement.....