InfoPath Dev

Doesn't the form open when you click "new" in the list?

 Im not sure how I missed that - thank you. All is working as expected I shall test further.

 Just to reiterate my previous words - thank you for all your help on this its greatfully appreciated. 

I'm happy I could help & glad to hear that you have things working!

 Thanks again. Just to get the setup clear in my head (as I keep confusing myself) if you were looking to create a front end (form base) with a back end (data store list\library etc) which is a glorified access database with forms and tables,  what would the preferred method used be?

Would you create a data connection library or a list library or a form library?  

If you open up InfoPath Designer and select "New" you can see the options for templates. If your data is flat (no nested repeating data) and your users like the functionality of search / filter / views in SharePoint, a list form is likely best. If you have complex data structures, you can use a form published to a library, but need to understand the limits of promoted properties for exposing that data. InfoPath can also be used to connect directly to Access or SQL database tables. To submit to Access / SQL or to a SharePoint list, you need to start with the correct template time. If you just start with a blank form - you can submit to a library, but won't be able to submit to a DB or a list (without code / web service / third party tools).