"1 recordset or would I need to duplicate the same recordset 5 times?":
you only need to use one recordset.
"When I am prompted to select fields to add to search it seems to have pulled through all fields from every table rather than the basic 6 from my recordset."
The search wizard will allow you to search on all the columns in your table, not just the ones that are returned by the recordset.
"Running this gives me a select field as chosen but with no data in, when I look at code its just a basic form with a simple select, no other code?"
You need to populate the select list with the values to search.
This can be done using a recordset or by populating the list manually