>>If I make a change in one form, how can I get the other form to recognize the >>updated data ?<<
It depends on what you mean by getting the other form to recognize the data changes. Do you need the other form(s) to reflect the changes to the current record in the updated form directly (like the form is a dashboard and is displaying the latest changes)? Or are you saying the user might switch to the form and navigate to the record and should see the recent changes? Depends on whether you are using direct VFP table access, local views of VFP tables, or remote data. For VFP tables you need to check out the SET REFRESH command. For local or remote views you need to Requery() the views, and probably tweak the SET REFRESH command. Note: the second parameter of the SET REFRESH command is the one to tweak. Getting this setting optimized will depend on the users need for fresh data vs. how much network traffic they can tolerate. If it is the dashboard scenario you need to consider the concept of a Form Manager object to message the other forms that need to perform some code to get the refresh to happen. Kind of what John was referring to in his framework answer. Rick White Light Computing, Inc. www.whitelightcomputing.com www.swfox.net www.rickschummer.com _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
