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.