Hey Honeybee,

Thanks for the input! Although I didn't try your idea, it got me
thinking. Since this is my first database, and I have been using
recordsets...I thought I would stick with them.

Not only did I need to include the UserID in the WHERE clause,
but also in the SELECT clause. This is what eventually worked...


Set rs = db.OpenRecordset("SELECT UserID AND Category From Categories WHERE UserID = " + Chr$(34) + cmbUserID.Text + Chr$(34) + " AND Category = " + Chr$(34) + cmbCategory.Text + Chr$(34) + ";")


Again, thanks a lot, and have a good one,
Ron