I'm creating this program for an old man that sorts bible verses by categories. The thing he wanted, though, was for an easy way to sort the files.

strCategory = Categories.Text
frmSearch.Hide
frmMain.adoVerses.RecordSource = "select * from tblVerses where fldCategory =" strCategory
frmMain.adoVerses.Refresh

The problem I have is with the recordsource, I gather. I don't know why it won't work (never taught how to do it in the second semester of VB). What the code is SUPPOSED to do (or in my mind) is get the category from the combo box Categories and place it in strCategory. After hiding that form, it's supposed to sort it by the category and refresh the main form. I don't know why it won't do it, though. A little help? I'd appreciate it. =)