How to search on table with 300,000 records

[waymond]

I have a search form with 4 unbound text boxes
company
loacation
sic
naics

I have a query that when the search button is clicked it looks for the fields on the form then it needs to bring up another form called company is not a subform. I tried every thing out there and it is very slow it takes over 5 minutes. Please help

 

[lupins46]

Are all these fields indexed in the table?

 

[TheAceMan1]

How are ya waymond . . . .

Sounds like your using one or more of the [blue]Domain Aggregate Functions[/blue], the turtles of access. If you are, drop them and use a [blue]Recordset with FindFirst or RecordCount instead[/blue] . . . much faster search for large recordsets!

See Ya! . . . . . .

 

[waymond]

no all these fields are not indexed will that help?

 

[TheAceMan1]

waymond . . . . .

[blue]Tek-Tips is all seeing if you can post code or SQL![/blue]

See Ya! . . . . . .