#Error - Form Field

[Access_Help]

Everything was displaying fine in the textboxes which contained some calculated values and then all of a sudden I was presented with #error?

I don't recall renaming any fields/objects..what could be the problem?

Database attached.
View attachment DB1.zip

 

[Minty]

Without looking at your database - If nothing has changed then it has to be the data that has to cause the #error.

What is the expression that is used in the offending textbox?

 

[ypma]

I am no expert but just looking at you control source for total students I used
#=DCount("Full_name","qry_mark_grid")# I think you have to use query in your formula , hope this food for thought

Regards Ypma

 

[static]

text105 references check62 which doesn't exist
Text99 references FieldName which doesn't exist

Your naming of controls is atrocious.

 

[ypma]

Access help : Further to my last post I have entered the formula for each of the Grades to obtain the percentages only. I have used the domain function and it work for me. Another way would be to do your calculation on a query .
others may have other ideas which they are free to comment'
Regards Ypma

 

[ypma]

Access Help. You posted a question, please have the courtesy to respond to replies . If you are no longer interested I will unsubscribe from this post.

Let me know it your problem has been solved.

Ypma

 

[Access_Help]

text105 references check62 which doesn't exist
Text99 references FieldName which doesn't exist
.

These were test fields, my bad - should have deleted them

 

[Access_Help]

Access help : Further to my last post I have entered the formula for each of the Grades to obtain the percentages only. I have used the domain function and it work for me. Another way would be to do your calculation on a query .
others may have other ideas which they are free to comment'
Regards Ypma

Great, strangely, DCOUNT has brought the values back.

Sorry for the late reply - I was away from office.

 

[ypma]

Acces help: Thank you for getting back to me , do you need any other help like counting the On targets, which for yes will be -1 .
Regards Ypma