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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only