Storing Calculated Fields

[tcshred]

Hi!

I know you're not meant to do this, but I can't think of any other way. ..

I have a score marking template for an internal audit. A criteria is either met, or it is not. All of these questions have Yes/No data type. each question has a weighting.

I have written a VBA function to work out the total score by using a bunch of If statements.

I need to store the final result in a table, by entering the answers (yes or no) into a form.

Is this possible?

 

[pr2-eugin]

Hello tcshred. Welcome to AWF..

As you have been read into Calculated fields do not have to be saved in Tables. All you need is the Yes/No values to be stored and when you need them you need to Calculate them, then and there. Using Queries, Unbound Controls on Forms. But no table storage.

 

[tcshred]

How do I create an unbound control on a form?

 

[pr2-eugin]

Did you just ask : How do I create an unbound control on a form?