Information générale
Catégorie:
Gestionnaire d'écran & Écrans
Titre:
Filtering Combo Box Problem
I want to filter the items in a combo box based on the value of a different combo box. How can this be accomplished as part of the rowsource SELECT statement without making the variable lcvalue public?
GOTFOCUS METHOD of Combo2
local lcvalue
lcvalue=This.Parent.Combo1.value
***Since lcValue is local, the filter in the following rowsource will produce an error message once this method is completed.
this.rowsource="sele prefix,imprint2,publisher from publishe into cursor cpublisher1 having publishe.prefix=lcvalue"
this.value=lcvalue
***Using publishe.prefix=this.parent.combo1.value as the filter doesn't work either.
Thanks in advance!
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement