Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Controlsource kills search
Message
De
18/07/2000 01:40:18
Jimmy Ditta
Twin City Electronics
Monroe, Louisiane, États-Unis
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Controlsource kills search
Divers
Thread ID:
00393649
Message ID:
00393649
Vues:
53
I have this Method run in the interactivechange event of combo1.

SET MULTILOCKS ON
=CURSORSETPROP("Buffering", 3, "intrancust")


SEEK Thisform.Combo1.value

IF FOUND()
Thisform.Text1.VALUE = chgperkt
Thisform.Combo2.VALUE = cut
Thisform.Combo3.VALUE = colors
Thisform.Combo4.VALUE = clarity
Thisform.Edit1.VALUE = p_descript
Thisform.Text7.VALUE = entered
Thisform.Text6.VALUE = invoiced
Thisform.Text5.VALUE = total_chg
Thisform.Edit2.VALUE = transdesc
Thisform.Text8.VALUE = company
Thisform.Text9.VALUE = track_num
ELSE
= messagebox('The record you searched for is invalid and should be deleted')
Thisform.Pageframe1.Page1.Combo4.VALUE = stocknum
ENDIF


Everything works beautifully - until......

I want to use this same form to append as well as search. In order to do that the Controlsource property of each object must be linked to its proper field (OR DOES IT? SHOULD I MAKE A METHOD THAT USES REPLACE AND LEAVE THE CSOURCE BLANK IN EACH OBJECT?)

Anyway, when I set the Controlsources and run the form, the search only gives the error messagebox. Is the Controlsource and the Rowsource fighting it out somehow?

All opinions are welcome and appreciated.
Thanks
JD
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform