Updating field in table based on calculated field in form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MacNut2004 - 21 May 2007 15:30 GMT

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

Reply to this Message

gumby - 21 May 2007 17:26 GMT

On May 21, 9:30 am, MacNut2004 <MacNut2...@discussions.microsoft.com>
wrote:

> Hello,
>
[quoted text clipped - 10 lines]
> 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

Reply to this Message

MacNut2004 - 21 May 2007 17:35 GMT

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?

> On May 21, 9:30 am, MacNut2004 <MacNut2...@discussions.microsoft.com>
> wrote:
[quoted text clipped - 19 lines]
>
> David

Reply to this Message

gumby - 21 May 2007 19:08 GMT

On May 21, 11:35 am, MacNut2004 <MacNut2...@discussions.microsoft.com>
wrote:

> 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
[quoted text clipped - 32 lines]
>
> - 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.

Reply to this Message

MacNut2004 - 21 May 2007 19:27 GMT

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

> On May 21, 11:35 am, MacNut2004 <MacNut2...@discussions.microsoft.com>
> wrote:
[quoted text clipped - 39 lines]
> Do you have an example of your database on the internet anywhere to
> download.

Reply to this Message