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

Hello

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?
LillyCAsked:
Who is Participating?
 
SimonCommented:
Glad to hear you've cracked it :)
0
 
SimonCommented:
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?
0
 
LillyCAuthor Commented:
Hi,
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).
0
 
LillyCAuthor Commented:
Hi,

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... :-)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.