Hi All

I am having what is a basic problem but can't understand why. I have created a subform and I now want to add a new field to this subfrm so I have added this new field to my query that the subform is based on and I am now trying to add this to the recordset, however when I close and save the subform and re open it I get a prompt with the new field, I have checked spelling but all is ok.

Anyone help?
Thx

What's the SQL?

erm you're about a year too late:p

Mile is just too thorough. :D

I happened to be browsing my old posts, guess his nose was bothering him ie who's online

Still at least I got a reply - only took a year:D