Update Function

In my form I have the following fields [CAGE] , [PROCESS], AND [TYPEOBSERVE].

CAGE and PROCESS are both drop down lists. and type observe is a memo box.
I would like to know if whenever I select a specific CAGE AND PROCESS and only then can I have the memo box [TYPEOBSERVE] update with the following information:

Review Routers for completeness
Verify calibration dates on the equipment
Review work instructions
Perform acceptance test on the selected sample(s)
Verify correct documentation as to the sample passed or failed test.

If needed I can send a blank database to anyone that can help
--
THANKS IN ADVANCE
~~
Thanes

You can add the following code to the After Update events of both your Cage and Process fields:
IF Me.Cage = "Whatever" and Me.Process = "WhateverAgain" then
Me.TypeObserve = "Review Routers for completeness. Verify etc"

If you want carriage returns at the end of each line, then it would look like this where chr(13) & chr(10) separate each line of text. (see post on Carriage Returns in Text boxes from today)

Me.TypeObserve = "Review Routers for completeness" & chr(13) & chr(10)& "Verify etc"

Hope this helps.

"Thanes" wrote:

In my form I have the following fields [CAGE] , [PROCESS], AND [TYPEOBSERVE].

CAGE and PROCESS are both drop down lists. and type observe is a memo box.
I would like to know if whenever I select a specific CAGE AND PROCESS and only then can I have the memo box [TYPEOBSERVE] update with the following information:

Review Routers for completeness
Verify calibration dates on the equipment
Review work instructions
Perform acceptance test on the selected sample(s)
Verify correct documentation as to the sample passed or failed test.

If needed I can send a blank database to anyone that can help
--
THANKS IN ADVANCE
~~
Thanes