I have fields in a subform that add the contents of other fields. These fields are placed in the footer and I have fields in the main form linking to them.

I have changed the name of some of the main fields in the subform and now I can not get the fields adding these fields up to work, even though I have changed the control source and even re-done these addition fields!!

Help pleas!!
tariq

Question: Have you changed the name of the FIELDS or the CONTROLS containing the fields?

If you previously had the control names the same as the field names (The default for acces wizards) but have now changed either the field names and/or the Control names then this could be the cause of the problem.

You can test this simply by ensuring that the control names are the same as the field names (This is not best practice but will help to identify the problem).

Hope this helps as a starting point
Regards
trevor from www.accesswatch.co.uk (http://www.accesswatch.co.uk)


[This message has been edited by accesswatch (edited 09-11-2000).]