Querying for all

[nipchop]

Hi,

I have a database full of suppliers. I have set up a query that allows users to select individual suppliers and view relevant statistics. This is done using a combo box. I would like to ammend this query/combo so that the user can also look for all (*) supliers and their stats.

Tim

 

[Darrylles]

Hiya,

You could add the string "All Suppliers" using the Additem method, then use "Select * from Suppliers" if this is selected.

Regards,

Darrylle "Never argue with an idiot, he'll bring you down to his level - then beat you with experience."