Matt, yes the values are strings. I fixed that but got some other errors. It's probably gonna be easier to just start over I think. I gotta be doing a million things wrong. Is there a tutorial somewhere (been searching for a couple hours this morning with little success) that might allude to a way of doing this. Or perhaps someone here could help me out. What I'm not sure of is how to assign the results of an SQL query to a combo box. In general, I know that this code loops through the values in the teamid field
from the team table
VB Code:
  1. Do Until rs.EOF = True 

  2.     Combo1.AddItem rs.Fields("TEAMID") 

  3.     rs.MoveNext

  4. Loop
I want something similar, that checks the game.hometeamid and game.awayteamid and if either one matches the value from the team.teamid (that's currently displayed in the Text1 textbox), it adds the item to the combo box.....inhale....exhale....ok.
VB Code:
  1. Do Until rs.EOF = True

  2.     Combo1.AddItem results from SQL query???

  3.     rs.MoveNext

  4. Loop
I guess that's my main problem. Also do I need to set up a seperate Recordset if I'm working with 2 different tables? Clueless at this point. Thanks for the help so far, though.