Hi everyone,

I'm a new user to Access 2010. I have a problem when switching from a form view to datasheet view in Access 2010. My calculated field appear as '#Type!' and '#Error', which is the control source for the field is from the sub-form. I've working this for few weeks but could not get the solution. I really appreciate if anyone can help me on this.

Thanks!

The short answer is that you will not be able to use datasheet view with your current form design.

__________________
Boyd Trimmell aka HiTechCoach (.com)
Microsoft Access MVP Alumni 2010-2015

Is that mean I need to change my form design and one more thing, when I create a query using that form, the calculated field seems not to be appeared as well. is it due to my form design?

Yes.

Only very simple forms can be be switch to datasheet view.

In over 15 users using Access I have rarely switch a form to datasheet view.

I find that a properly normalized (well design) database will not display properly if datasheet view from a form design to show related data from multiple tables.

If you can flatten (de-normalize) the data into a single row of a query then you can base the form on that query. This design will allow you to switch the form to datasheet view.

__________________
Boyd Trimmell aka HiTechCoach (.com)
Microsoft Access MVP Alumni 2010-2015