When I run a SQL from my code and try to set the value retrieved back to a recordset. I keep getting the Type Mismatch error. Can someone enlighten me abou this? I've already checked to make sure that the field type are not conflicting or anything. But I can't tell what I'm missing. Thanks in advance.