Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Son of Accused of Violations I'm not committing
Message
From
24/03/2005 07:58:45
 
 
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Environment versions
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00998499
Message ID:
00998806
Views:
17
This message has been marked as the solution to the initial question of the thread.
Phew!

I seem to have cured this problem. Consider the following:

Code for IRChange() of combo:
With Thisform
  .txtRoute.Value	    = this.value
  .txtRoute.refresh()
  .cRouteNo	    = this.value
  .cDirectn	    = this.List( this.ListIndex, 3)	&& Directn is 3rd in list
  .txtDirectn.value   = .cDirectn
  .txtDirectn.refresh()
  .cmdPrint.enabled   = .T.
  .cmdPreview.enabled = .T.
EndWith
Having selected from the list box, the accompanying text box, .txtRoute, is assigned the value from the list box, taken from the select cursor/table. Now, whilst writing the form, I'd set its ControlSource to ROUTE.Route (its PK), but now I was "overwriting" it with the cursor's .Route (taken from select of the Route table). No immediate complaint from the form though, until I click the preview button. As I said in the orig message, the error was popping up somewhere between the two events, but not where it could be trapped. Strikes me that somewhere it should have said it didn't like it.

Anyway, I cleared the text box's ControlSource and now don't get the error. Still don't understand why the message only happened on certain records and why in such a strange manner.

Terry
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform