Can someone tell me what is wrong with this line:

SQL = "update tblGroupAndMembers set group_id = '" & !group_id & "' where member_id = '" & memberId & "'"

I keep getting 'Data type mismatch in criteria expression.' If i hard code memberId then I dont get the error. I dont understand what I am doing wrong. i defined memberID as Integer. The data Type for member_id in the tblGroupAndMembers table is number with field size integer. Can someone please help?

This line is in the following code:

With rstMemberId
     SQL = "insert into tblGroupAndMembers(member_id) values('" & !member_id & "')"
     db.Execute SQL
     memberId = !member_id
     .Close
End With

      Set qdfTemp = db.CreateQueryDef("", _
        "SELECT group_id FROM tblGroupNames WHERE group_name = '" & cmbGroupName & "' ")
    Set rstGroupId = qdfTemp.OpenRecordset()
    With rstGroupId
    SQL = "update tblGroupAndMembers set group_id = '" & !group_id & "' where member_id = '" & memberId & "'"
     db.Execute SQL
                   .Close
End With


Thanks!

If Member ID is an integer, then

SQL = "update tblGroupAndMembers set group_id = '" & !group_id & "' where member_id = " & memberId

Don't surround it with single quotes.

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division