Hi Nikki.
>
>The problem is they now want an option to select "ALL", this is not stored in the table. Could you please give me any idea's how to do this. Also "ALL" needs to be at the top of the combo's.
>
IF You set the RowSourceType of your Combo to SQL you can use something like this as the RowSource:
SELECT Yada, nada, blah from SomeTable UNION Select ' -- All -- ' as yada, SomethingElse AS nada, YetSomethingElse AS Blah from SomeTable ORDER BY Yada INTO Cursor MyCursor.
Then, in the valid of the combo, you would have to take some specific action if ' -- All -- ' was selected.
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