Best way to find a record?

[Drak]

If I have a form that's bound to a table, and want to view a specific record, what's the best / most efficient method of doing so?


I use the "Filter" property on some forms, or use the DAO recordset object on others.
Then some, I do it right inside the query (form bound to a query) and the criteria would be a text box/combo box or similar.

[TheShabz]

It depends on whether you want the user to be able to modify a record or have it as view-only. If modification is needed, then bind it to the table and filter. if its view-only, then bind the form to a query and use the textbox.

[Drak]

It depends on whether you want the user to be able to modify a record or have it as view-only. If modification is needed, then bind it to the table and filter. if its view-only, then bind the form to a query and use the textbox.

So If I have a combo box filled with customer names, on the "afterupdate" event of the box, set a filter to the form?
I would like them to be able to modify the information. Current I use DAO.FindFirst to return a record. But using the form filter would be more efficient?

[TheShabz]

I wouldn't use the combobox in that manner, as once you have a significant amount of customers, scrolling to find a customer becomes a pain. Try this Find as you Type from Allen Browne