Add "all" option in a combo box filter

[nadoona]

Hi,
I have a form contaning a combo box and a subform. I'm using the combo box to search by the company name and in it's after update event I requery the subform. This part is working very well.

My question is: how can I add an option called "all" in the begining of the combo box (that contain the companies' names) so that the subform gets the information for all the companies in one time??

Thanks

 

[RichO]

How are you populating the subform after combo box selection? Query, filter, etc...

 

[nadoona]

Sorry I don't understand what "populating" is. Actually I'm still a beginner. Anyway here's what I'm doing:

In the subform I have a query that gets all the inforamtion for the chosen company. So I requery the query in the after update event of the combo box.

I don't know if that is what u mean or not.
Anyway thanks for ur time.

 

[RichO]

So then you are using a query to populate the subform.

What kind of expression are you using so the subform contains the records related to the combo box selection? Are you referencing a form control from the query or are you filtering the subform?

 

[nadoona]

I requery the subform in the after update event of the combo box. So I get all the records related to what's in the combo box. Actually that part is working well. The problem is how to add the word "all" at the begining of the combo box so that it gives me all records available and not just a specific one.

Thanks for ur time and help.

 

[Rich]

See if this article helps
Article ID: Q128881

 

[nadoona]

Thanks a lottttttt "Rich".
I found the way to do it.
Thanks again