Eljefegeneo
Still trying to learn
- Local time
- Today, 04:03
- Joined
- Jan 10, 2011
- Messages
- 902
I have a simple search form that searches for, among other things, the surname.
The criteria for the query that is used for the search is very basic: Like "*" & [Forms]![frmSearch]![txtSurname] & "*". I can get any record I want except for the first record, that is, I have searched for the name that appears on the first record in the table where the search is made. I have even tried to search the city for this person and the name does not appear in the search.
And I have tried the usual remedies, compact and repair, etc. The query doesn't exclude any criteria, and there is nothing on the search form to exclude any names. I can search for ClientId number and the record does appear.
Is this just one of the strange quirks of Access (version 2010), or perhaps I have inadvertently done something to cause this.
It is not a big deal, but it is a conundrum worth investigation.
The criteria for the query that is used for the search is very basic: Like "*" & [Forms]![frmSearch]![txtSurname] & "*". I can get any record I want except for the first record, that is, I have searched for the name that appears on the first record in the table where the search is made. I have even tried to search the city for this person and the name does not appear in the search.
And I have tried the usual remedies, compact and repair, etc. The query doesn't exclude any criteria, and there is nothing on the search form to exclude any names. I can search for ClientId number and the record does appear.
Is this just one of the strange quirks of Access (version 2010), or perhaps I have inadvertently done something to cause this.
It is not a big deal, but it is a conundrum worth investigation.