I have a main form with all my records in it, and I want to create another form where I can enter the criteria in just one field (the reference ID) and click on search and it will open up my main form with the relevant record.

How can I do this without writing any code?

Any help would be much appreciated.

You can have a "pop-up" box appear if you create a query with parameters that runs the form. Create a query, and in the Criteria for your field Reference ID, type [Enter Reference ID]. When you open you form, you will be prompted to enter and ID.

Thankyou