Hi Jason,
Thanks for getting back to me.
Sorry I worded my last reply badly, when using the dataassist wizard it works on a single table or view, I cant find any way to use a recordset. Am I missing something or are you taking about using the join query as a view.
Thanks
Mark