I have a form which I want to filter based on a combo box (ComName),
which is linked to a table. I have 1000s of records, but want to
select a specific company name from my Combo Box (ComName) and only
show records for that company. Any help please.

On Jan 13, 5:01*am, Paul <burnsp... (AT) hotmail (DOT) co.uk> wrote:
What is your issue? In the combo's afterupdate event you could do
something like
Dim strFilter as string
strFilter = "CompanyID = " & Me.ComboCompany
Me.Filter = strFilter
Me.FilterOn = (strFilter > "")

Or is it the act of scrolling thru a combobox with 1000s of records?
You could create a search form and use the search form instead of a
combo.

On Jan 13, 3:14*pm, Patrick Finucane <patrickfinucan... (AT) gmail (DOT) com>
wrote:
Hi - Each record has the name of the Company in the field named
(Company), I want to insert an unbound Combo Box to allow users to
select a company name which will then filter the records and only show
records for the selected company.

I also have reports/search forms already setup but some of the users
want the filter otion to allow them to scroll throught records for the
select company