Combo Box move to selected record

[toolsofministry]

Is there any faster way to access the first record, could possibly have more than one fullname in the table , than using the following code

FraVisitationUpdate.Visible = True
TheNames.Recordset.MoveFirst
Do Until Me![txtFullName] = Me![DBCombo1].Text
TheNames.Recordset.MoveNext

This appears slow with 3000 names.

Thanks

 

[CajunCenturion]

You might want to take a look at the .Filter property of an ADO Recordset. Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein