How do I save the result of an SQL COUNT query with VBA in Access 2007?
===

I'm trying to count the number of records in a table that meet a certain criteria.  My preference is to use SQL, not Dcount, as I want to get better at SQL.  Here's my current code below:

    Dim countString As String
    Dim count

    countString = "SELECT COUNT(*) FROM `Engagement Letters` WHERE 'Client ID' = " & Me.cboSelectClient

    count = CurrentDb.OpenRecordset(countString).Fields(0).Value

Yeah I know, I've used spaces in my tables and field names - I will change that.  Though I think I should still be able to run this query as is, so I will leave it as is for now.

When I run the above, I get runtime error 3464 - data type mismatch in criteria expression.  I've had the below dcount function work fine:

    count = DCount("[Engagement Letter ID]", "Engagement Letters", "[Client ID] = " & Me.cboSelectClient)

And also the below COUNT query without the WHERE works fine:

    "SELECT COUNT(*) FROM `Engagement Letters`"

My knowledge of SQL is very minimal, and my knowledge of more advanced VBA is also quite minimal, so I'm not sure where I'm going wrong.  Can anyone help me with this?