I have looked at your database. I do not understand why your last 2 records do not get found via search.
I notice you have another table and other forms and that you are using macros.
Your voters table is not normalized. You have several subjects in this 1 table. Your Category 1,2 and 3 should be a separate table.
I don't understand why the autonumber PK values for field ID for these records is 3831021 and 3831022. The original 200 records are 1 -200.
I'm not sure why, when opening the search form on start up it shows only the record with ID 200??
Sometimes it opens with only the first record Angela Hortert???
I deleted the ID field, then recreated it, autonumber, PK so now Tommy Rogers is ID 201, and James Jennings 202
The records are definitely in the voters table. But they are not being found via search???
I don't use macros so can not debug them. I don't know what else, if anything, you may have done (even unknowingly) to cause the type of activity. It could be some corruption; could be some properties or code interfering with something???
I type "jam" in first name and can see a count of 4, but there are no records displayed???
If I leave all criteria blank and click search, I get the first record only and a count of 200.
Seems to be same code as in the sample database I submitted previously --it works, even with added records as discussed in the PM -- so I don't know what may lurk beneath the surface of your database.
I just tried taking the SQL (recordsource)
and modified it to
Code:
SELECT *
FROM Voters
WHERE VoterFirstname Like 'james*'
ORDER BY VoterLastname;
I get 2 records, one of which is James Jennings
If I run a query
Code:
SELECT *
FROM Voters
WHERE VoterFirstname Like 'jam*'
ORDER BY VoterLastname;
I get 5 records, including James Jennings.
I found an issue with the combo . The records for Jennings and Rogers did not have Districts . I entered MadeUp for them.
However, when I code specific query
Code:
SELECT * from Voters where VoterFirstname Like '*' AND VoterLastname Like '*' AND VoterDistrict Like '*' ORDER By VoterLastname;
I can see all records???
Soomething is interfering with what is being displayed/ I don't know what. The count is correct but the displayed records???