Information générale
Catégorie:
Gestionnaire d'écran & Écrans
Hi Tom.
>> Once the name is chosen, I need to create a variable for the chosen name to pass to a query. (1)How do I pass a variable from a combo box to a query. <<
Like Nancy, I am a little bit confused as to what your problem is. However, I'll give it my best shot ;-)
Do you mean that you want to use what is selected in the combo box to be used to filter some other result set? If this is the case, you can put code similar to this in the combo's valid:
SELECT Yada, Nada, Blah, and yet more Blah FROM SomeTable WHERE SomeTable.SomeField = This.Value INTO CURSOR Temp
Now, what you do with the result cursor, is entirely up to you.
So tell me, am I close?
Marcia
Précédent
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