Some tips/suggestions when posting to make things better for all who read:
- use code tags for anything more than 2 or 3 lines (also will prevent forum from interjecting spaces at the 50 character point, even for one line)
- state what line triggers the error. In your case, it could be at least 1 of 3 or more
Even when this current problem is solved, I expect a new error triggered by your sql statement as ParentCIN appears to be text data and the form field reference isn't being wrapped in single quotes. Agree that more clarity or a db copy is required.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.