Does this look fine?<BR>The txtID is a variable that is holding the ID value from another table.<BR><BR>strSQL2 = "SELECT ID, DeptName FROM DeptInfo WHERE ID=" & txtID
Looks OK, whats the problem ?
Not sure, I just wanted to make sure it was not the query string.<BR><BR>Thanks......
What has a querystring have to do with anything??
Ak,<BR>it is a *query*<BR><BR>and it is, in fact, a string <BR><BR><BR>:)
guess you are trying to get witty in your old age huh
I was just pointing<BR><BR>out that you are wrong.<BR><BR>all he needed to do was put a space between<BR>query and string and voila.<BR><BR>must have mistyped the word.