Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Record Out of Range - 2 linked dropdown lists
Message
 
 
To
20/11/1999 09:46:39
Gil Munk
The Scarborough Group, Inc.
Baltimore, Maryland, United States
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00293448
Message ID:
00293463
Views:
21
Gil,
local luViewParameter
luViewParameter = this.Value
Requery( "TheSecondView" )
with this.parent.cboSecond
   .Requery()
   .ListIndex = 1
endwith
>I've two dropdown lists, each source to their own view. The second dropdown list's view's view Parameter is the id of the first list's currently displayed value. I requery the second view when the 1st dropdown value is changed by the user. If the user selects a value whose child table - sourced to dropdown 2 - has fewer records than the previous one the refresh of list 2 gives the record out of range error. I know there's a trick that's probably in the Hacker's Guide to VFP but I haven't got that.
>
>I have a feeling that I should change a pointer in the second list but have not figured out where or what yet.
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform