Hi.
I need help!!
I have two combo boxes and a button on my form. One combobox is for company name and the other for product.When the user selects a company (For e.g. IE) and a product (For e.g. Server), on command button click the list of servers for the particular company are displayed in datasheet view. I have achieved this goal.
My problem is how to display all the products for a particular company. Say, If i select a company name and write 'ALL' in the product combo box, all the products for that company need to be displayed.
Simply put,I need to check in the query if the text entered in the combo box is 'ALL'.
How do i achieve this?Is it possible?
Thanks.