2002-2003 bringing subtotal from a subform to a main form

C

Cathy

I have a front end/back end designed database that was created in Access
2000. I have some XP users that want to use the database, so I attempted to
created an XP front end using Tools/Database Utilities/Convert Database. I'm
having problems with bringing information from the subform back to the main
form. Is there a reference that needs to be added? If so, which one? Is
there any other change between Access 2000 and 2002/2003 that might be
causing this problem?

My code is:
=IIf([subCategoriesComments2].[Form].[Visible],[subCategoriesComments2].[Form]![subCol1_Amount],(IIf([subCategoriesComments1].[Form].[Visible],[subCategoriesComments1].[Form]![subCol1_Amount],(IIf([subCategoriesComments].[Form].[Visible],[subCategoriesComments].[Form]![subCol1_Amount],0)))))

Thanks for any help you can provide!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Populate main form from subform record 0
showing a subform based on the main form 5
Requery main form after subform update and not lose place in main form. 3
Update Main form from continuous subform 2
Requery subform control from Main form 0
Master - Child links not working in 2007 0
Master Child link being broken. 2
Passing a value from subform or main form to subform query 4

Top