Thanks for all the help Jason,
In boatenquiry_insert.php I cannot seem to get the correct recordID number showing in the
Boat Record No: Box
I am testing with RecNo 9474 but when opened the page pulls in 8512 which is the first record in the table boats.
I cannot see why Recordset DetailRS1 does not select the correct record but only the first record.
I have used RecNo, recordID and colname all give the same results. 8512
I am attaching the latest ammended file. and an image which I think shows the problem.