Limit Combo Box Options

[mjanalyst]

Hello,

I am looking to limit combo choices that the user can select. I am having the records filtered to only show the same company. But I would like user to add new records only for that company that is already filtered. The user chooses the companies via a combo box that list all of the companies. Is there a easy way to limit that list to only show the company that the form is already filtered too? Please let me know if you need further information. Thank you.

Mike

 

[binbin]

There's a lot of "companies" in that post, I'm a little bit confused on how you want the companies to be filtered, is it by supplier, customers, products, etc. ?

Just to give it a shot. What I usually do is base the combobox record source on a query then just choose the field you wanted to get filtered and then place a value on the criteria of the field in the query, perhaps a value from a form control?