Aha! Sorted it after looking at the SQL string. It was a boolean field that was throwing a wobbler.
Perfect. So to get the ID of the new record it just pulls back a recordset with the form details that have just been posted and ordering by ID DESC? I guess it doesnt have to be any more scientific than that!
Thanks Ray