Search field not pulling through all the data from my table in MS Access


I have created a search field in my form but its not bringing through all my data from the table.

I have created my table by merging 4 different tables, 1 of which was a read-only table that I thought might be the problem as one of the people I am trying to search is on that table, so I re-entered that person into the table but they still don't appear on the search - I'm baffled.

Any ideas or suggestions?
LillyCDatabase DeveloperAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Have you tried using wildcards in your search field ?

It is not clear to me at least, exactly what you're doing or how you've designed it. Have you done a union query to run your search against, or have you actually built a new table out of four others?

Does your search field look at a single field or are you searching entire records for a keyword?
LillyCDatabase DeveloperAuthor Commented:
Search field is just a normal combo box based on the "find the record on my form based on the value I have selected" wizard option.

Data was imported from 4 different Excel spreadsheets into a new table.

As an example, in one case, when I type surname in combo box, it brings 3 out of possible 5 people ( 2 missing live on the same address and have same second name but different first name).
LillyCDatabase DeveloperAuthor Commented:

Just to let you know that I have sorted it :-)  The import from Excel was not alphabetically sorting all people under same names for some reason, so just ORDER BY in combo box row source has sorted it out...

Thank you for all the effort... :-)
Glad to hear you've cracked it :)

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.