I know I can use the filter button on a form to act as a search engine. However beings as some of the users would have very minimal amount of computer knowledge I wanted to make a search engine operated from a Button on the form.

Also having very little knowledge of Access and making most things up as I go, creating a search engine seems a bit daunting.

I believe I can use RecordSetClone to make a Search Engine but apart from that I do not know where to start.

Please tell me I do not have to make all new forms.

This article may seem a little offputting when you first look at it and the code required. But if you hang in there it will allow you to create a form that your users can use to search for data in your database.

http://support.microsoft.com/support/kb/articles/Q210/2/42.ASP?LN=EN-US&SD=gn&FR=0&qry=QBF&rnk=2&src=DHCS_MSPSS_gn_SRCH&SPR=ACC2000

Thanks I will take a look and let you know how I get on.