So my database has a main data entry form that contains several subforms. I don't understand it, but the code works in some of hte subforms and not others. The only real difference is that the id (Primary key) is called something different - assume this is the problem, but doesn't make sense. I can't change the field name since this data is exported to others that need that fieldname for data analysis. Anyone have this similar problems?? Any ideas on how to fix this? Thanks!