Thanks for the link Paul

I have being amending an example to suit my needs but the examples were based on the row being added to the same table however I am wanting to add mine to the second table on my form. In addition my VBA knowledge is a work in progress.

I think I've sorted the 2nd table entry but have hit a slight problem in that my 2nd table contains merged rows and because of this the code below is giving me a runtime error 
Set oRng = oTable.Rows.Last.Range
How can I change this to accept merged cells? Would it be better to enclose the entire code for you to view?

Thanks again

Gav