Updating field in table based on calculated field in form

[Guest]

Hello,

I have a form that has a calculated field - check box - called "Audit Met."
This updates to "true" if all the audit requirements were met on that same
form. What i want to have happen is to update another field called
"AuditComplete" in another table - ProjectInfo - to "true" if this field on
the form is true. That calculated field only exists on the form. How can I
update "Audit Complete" for all the records in the ProjectInfo table to
"true" after the fact?

Thank you and please let me know if this is confusing.

Thanks,
MN

 

[gumby]

Hello,

I have a form that has a calculated field - check box - called "Audit Met."
This updates to "true" if all the audit requirements were met on that same
form. What i want to have happen is to update another field called
"AuditComplete" in another table - ProjectInfo - to "true" if this field on
the form is true. That calculated field only exists on the form. How can I
update "Audit Complete" for all the records in the ProjectInfo table to
"true" after the fact?

Thank you and please let me know if this is confusing.

Thanks,
MN

Are your two tables linked in anyway? You should not attempt to pass a
calculated field to a table.

If they are linked, calculate in a query.

David

 

[Guest]

Well...not really. What is happening is that I have one form with the list
of all projects. You double click on one, and it brings up an audit
questionnaire. There are a series of checkboxes and such and if all of them
are checked....the "Audit Met?" button on the form is checked as well.
(automatically) What I want to have happen then is that when you close out
of the questionnaire form to view the form of all the projects, i want that
particular project number to change color or SOMETHING to show that its audit
has been completed.

Any ideas of the easiest way to accomplish this?

 

[gumby]

Well...not really. What is happening is that I have one form with the list
of all projects. You double click on one, and it brings up an audit
questionnaire. There are a series of checkboxes and such and if all of them
are checked....the "Audit Met?" button on the form is checked as well.
(automatically) What I want to have happen then is that when you close out
of the questionnaire form to view the form of all the projects, i want that
particular project number to change color or SOMETHING to show that its audit
has been completed.

Any ideas of the easiest way to accomplish this?








- Show quoted text -

Which table does the project number belong to? Does the project number
show up on the audit form?
Do you have an example of your database on the internet anywhere to
download.

 

[Guest]

The project number is from the questionnaire table. (which is joined wiht
the project number from the project info table in the source query) and yes,
it is on the form. Unfortunately, cannot post the database anywhere on the
'net...because it's a company database.

Thanks,
MN