Thanks for the input,

I figured it would be something that is beyond what I know about databases.

I have another question regarding how to post query results in Office 97 VBA

Here is my code:

Code:
Sub cmdUpdate_Click()
Dim dbs As Database, rst As Recordset
Dim strVariable As String

strVariable = Forms!StateSelectNew.cmbStateSelect
    
    
strSQL = "SELECT DISTINCT * FROM OTC_SITES WHERE [SITE_STATE] = " & "'" & strVariable & "'"
    
    Set rst = dbs.OpenRecordset(strSQL)
    Set dbs = Nothing

End Sub
After the query runs, I don't get any feedback.
Any ideas?
Thanks
Jazzbass