Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: alan shulman
  Where is alan shulman?
 utica
 New York - United States
 alan shulman
 Tags
Subject: Closing table issue in form
Thread ID: 289145 Message ID: 289145 # Views: 34 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Forms
Date: Tuesday, December 28, 2010 5:49:38 PM         
   


In my form I have some code that lets you browse a table, that is not in the data environment of the form (thats another table). I have this code in click:

use 'interest table' IN 0 INDEX 'interest table' ALIAS int
SELECT int
brow
USE IN 0

I did this so I only would close the 'interest table'. This seems to work, but when I get back to the main form I have a combobox with policy numbers that you select and have this method I created that is called in the interactivechange event:

y=thisform.combo1.value

SEEK y
IF ! FOUND()
MESSAGEBOX("POLICY NOT FOUND")
ENDIF

thisform.refresh

This refreshes the data to correspond to the policy you selected. The problem is, after I view the 'interest table', come back to my main form and select a policy, I get my "policy not found" message. When I clear that it brings up the new policy data, so it works. But I can't see why I'm getting that message when the policy is on the list.

ENTIRE THREAD

Closing table issue in form Posted by alan shulman @ 12/28/2010 5:49:38 PM
RE: Closing table issue in form Posted by Stefan Wuebbe @ 12/28/2010 6:31:21 PM
RE: Closing table issue in form Posted by alan shulman @ 12/28/2010 7:49:22 PM
RE: Closing table issue in form Posted by Stefan Wuebbe @ 12/28/2010 8:07:25 PM
RE: Closing table issue in form Posted by alan shulman @ 12/28/2010 8:34:32 PM
RE: Closing table issue in form Posted by Ilya Rabyy @ 12/28/2010 10:28:10 PM
RE: Closing table issue in form Posted by Stefan Wuebbe @ 12/29/2010 1:46:25 PM
RE: Closing table issue in form Posted by Ilya Rabyy @ 12/28/2010 8:16:16 PM