Search large database based on Two field

[jmcorkhill]

Hello,
I have a database of about 3 million businesses and I am having trouble creating a form to search on company name and postcode without it being very slow.

Or alternatively is there another format i can convert it into. The final product need to be put on a cd and run so you can search the dtabase.

Thanx

 

[RuralGuy]

You will get better assistance if you will describe the code you are using to do the search. What is "very slow"?

 

[Dennisk]

Normally with this many records you would have an unbound field and a combo box with no record rource ,
in the after update event for the unbound control either generate the SQL for the recordsource with a where clause

ie SELECT tblCustomer.Surname, tblCustomer.forname WHERE [Surname] LIKE '" & ME!UnboundControl & "'*"

or use a query with the criteria from the forms unbound control and use that as the recordsource for the combo box.