I can't seem to figure this one out. I have a form that is built on a query. One of the fields is a calculated IIF statement. When I view the form as a "single form," this field is correct for each record. However, when I switch to "datasheet" the column for this field becomes filled with #NAME?. Any thoughts?