Thanks for the reply. I tried different combinations and options, and the only one that seems to work is when one of the options is "Window Loaded". That is the only one that refreshes the table when the form opens.
David M. ETSU From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook Sent: Friday, May 30, 2008 12:55 PM To: arslist@ARSLIST.ORG Subject: Re: SOLVED: Tables not refreshing "On Open" ** I would also use Display vs. Window Loaded. Display only fires when an existing record loads. Window Loaded fires after the default values are loaded on a form (which could realistically be the best choice only in Search or New mode), but before the data is loaded. Using Display also removes the need for the $OPERATION$ keyword. Rick On Fri, May 30, 2008 at 9:46 AM, Thad K Esser <[EMAIL PROTECTED]> wrote: ** Make sure you take off the "Window Open" condition, otherwise your table will refresh twice every time the form opens (you can see it in the logs) Thad Esser Remedy Developer "Argue for your limitations, and sure enough, they're yours."-- Richard Bach "Morrison, David A." <[EMAIL PROTECTED]> Sent by: "Action Request System discussion list(ARSList)" <arslist@ARSLIST.ORG> 05/30/2008 09:26 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject SOLVED: Tables not refreshing "On Open" ** It says "click to refresh. I added the condition "Window Loaded" and it is now refreshing when the form opens. Thanks to all who helped! Have a great day!! David Morrison East Tennessee State Univ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Hall Chad - chahal Sent: Friday, May 30, 2008 12:19 PM To: arslist@ARSLIST.ORG Subject: Re: Tables not refreshing "On Open" ** When you say the table doesn't refresh, does it still display "Click to refresh" within the table field? Or is it just an empty table? If it doesn't have that wording and its just empty, then it refreshed but didn't find any matches. In which case you should check your qualification. Since you say it only fires on Window Open, that is before any values have been loaded into any fields. So if the qualification references any other fields on the current form then its search qualification will probably find no matches. You would need to change it to Window Loaded (or maybe just Display) if that is the case. Chad Hall (501) 342-2650 ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Morrison, David A. Sent: Friday, May 30, 2008 11:13 AM To: arslist@ARSLIST.ORG Subject: Re: Tables not refreshing "On Open" Only condition is Window Open. Thanks for replying. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook Sent: Friday, May 30, 2008 12:04 PM To: arslist@ARSLIST.ORG Subject: Re: Tables not refreshing "On Open" ** David, what are the firing conditions on this Active Link? Rick On Fri, May 30, 2008 at 8:56 AM, Morrison, David A. <[EMAIL PROTECTED]> wrote: Good day everybody, Strange problem that is driving me nuts. I have an Active Link that has as one of its actions a Change Field on a table with the option being "Refresh Table". The worklog says the qualification passes and lists the action, but the table does not refresh when the form opens. Only one view and all permissions have been checked. Any ideas would be greatly appreciated. AR 7.1 patch 2 Windows Server 2003 SQL 2005 David Morrison East Tennessee State University ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org <http://www.arslist.org/> Platinum Sponsor: www.rmsportal.com <http://www.rmsportal.com/> ARSlist: "Where the Answers Are" __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ ************************************************************************ * The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please resend this communication to the sender and delete the original message or any copy of it from your computer system. Thank you. ************************************************************************ * __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ ***IMPORTANT NOTICE: This communication, including any attachment, contains information that may be confidential or privileged, and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message is strictly prohibited. Nothing in this email, including any attachment, is intended to be a legally binding signature.*** __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"