creating a more efficient search

Hi there,

I have finally managed to find some time to fix this, it was a simple thing in the end (sigh).

I hope this is useful to you now :)
 

Attachments

Me.RecordsetClone.FindFirst "[Number] = " & Me![QuickSearch]

this code wont work and says there is a syntax error but i dont understand where it is going wrong if it works for yours?
 
Check your field names and make sure they are the same. The database I posted above is a modified version of the one you have posted a little bit earlier.

"Number"in this case refers to the Primary Key of the table where the data is being collected from. I have just unzipped and checked the database I posted is working okay and it appears to be working fine over here.
 

Users who are viewing this thread

Back
Top Bottom