weird search result

[kingsgambit]

I have build a electronic library for my company.
But when I go to the search form a enter text for it to search by, either whole text or part text. It sometimes finds all the records matching the text or sometimes only shows some of the results.
I have attached to database, if somebody could have a quick look for me to see why it is doing this.
On the search form enter "the all" in the title it should return 200 plus records try a few times and see what happens.

 

[dcx693]

You didn't attach the database (as far as I could see). What is the code you are using for the search mechanism?

 

[kingsgambit]

Sorry about that hear is the database

 

[kingsgambit]

the datbase is to big to attach, but this is what I use to search

Me.searchresult.RowSource

= "SELECT Bookrecord.RecordNo, Bookrecord.Title, Bookrecord.Edition FROM Bookrecord WHERE (((Bookrecord.Title) Like '*' & [Forms]![frmsearch]![Title] & '*'))ORDER BY Bookrecord.Title;"

Is there a better way?

 

[dcx693]

Is there a better way?

Yes, using proper syntax!


Me.searchresult.RowSource="SELECT Bookrecord.RecordNo, Bookrecord.Title, Bookrecord.Edition FROM Bookrecord WHERE (((Bookrecord.Title) Like '*" & [Forms]![frmsearch]![Title] & "*')) ORDER BY Bookrecord.Title;"