Today I get to answer my own question,lol (type the right key words in google this time).
To set the form recordset property to the ado record set use the following:-
Set me.recordset = rs
so using the code above my code would look like
Set me.recordset = rstCustomer
Hope this helps anyone with the same problem
Dave:thumbsup: