Hi Sal and thanks for the quick reply.
I am using a pointer, that points to my data base. The code is here:
Private Sub Form_Load()
Set DB = CurrentDb()
Set MyRS = DB.OpenRecordset("tblDecClients", dbOpenTable)
MyRS.Index = "PrimaryKey"
Private Sub txtInputSearch_Change()
Dim strSeek As Variant
Dim PosinMyRS As Variant
MyRS.Index = "LASTNAME"
strSeek = Me![txtInputSearch].Text
PosinMyRS = MyRS.Bookmark
.Seek ">=", strSeek
If .NoMatch = True Then
MyRS.Bookmark = PosinMyRS
As you can see, on the form load I force the indexing on the primarykey, but when I go to the txtInputSearch_Change(), I have to index it on the last name to search for the first approximation. In other words if I start inputing Jo, the results will imediatly jump to the closest match, for example Johnson and fill out the other fields with the corresponding data. My problem is, I want to make this routine pick two inputs simultaneously, but when I do this, it is impossible to find the correct one, because the first name is not indexed and he will never find it.
I hope I expressed myself in an understandable way.