If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Update Function
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
UK postcode issue | Lapchien | Running & Setting Up Queries | 6 | June 11th, 2004 09:06 PM |
Help w/ User-Defined Function | Tom | Worksheet Functions | 15 | April 7th, 2004 01:04 PM |
Modify "Remove Dots" function | Tom Bock | Worksheet Functions | 3 | March 15th, 2004 09:28 PM |
Function not evaluated | Srinivas Chundi | Worksheet Functions | 1 | January 31st, 2004 07:37 PM |