Information générale
Titre:
How to pass a variable to SQL statement.
Hello all. Another noob question.
I have 2 fields. One is a text box, the other a combo box.
The LOST FOCUS property of the text box assigns its value to a xVariable
Then it populates (or tries to)the combo box with:
thisform.combo1.rowsource="select names from table1 where names LIKE xVariable into cursor Z"
In other words, I want that if xVariable is "GA", the combo box is populated with all the names that start with GA.
I have tried several posibilities with no success. What am I missing?
TIA
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