>Thanks for your reply - I have tried this and get the error "Field phrase not found" - I have checked and the fields are definately in the view but it still occurrs.
>I am considering creating another field in my table to hold the firstname and surname together...
>Thanks again

What I gave you definitely works for a table (I didn't try it with a view), did you have the view name more that once?

I guess your right and the easy solution would be to concat them in the view.

I've just tested this with a view and it appears you need to specify the view in both fields.

RowSource = trim(view.field1)+" "+trim(view.field2)