Anyone know how I can run a SELECT SQL query in VBA and get the resulting row into a string variable? I've tried just using variable = docmd.runsql(statement), but that produces errors. There must be a way to do it that I'm just not seeing (probably because I hate Access). Or, to make things simpler, is there any way (in VBA) to access the value in a column of a combo box other than the bound column? combobox.value just returns the value in the bound column, but I need the value from a different column. TIA all. I hate access.