This is probably extreamly simple, so thanks for any help because the things I am trying don't seem to work.
I have a subform called volsub (continuous) in a form called test. Volsub has a field called z60_num and a total field for z60_num called z60_total. In test I also have a field called z60_num which needs to equal z60_total from volsub.
I have tried to use =[forms]![volsub]![z60_total] in the control source on z60_num in test. This returns an error saying volsub does not exist as a form in the database.
I figure that I must be overlooking the obvious so thanks in advance. GGuy
I have a subform called volsub (continuous) in a form called test. Volsub has a field called z60_num and a total field for z60_num called z60_total. In test I also have a field called z60_num which needs to equal z60_total from volsub.
I have tried to use =[forms]![volsub]![z60_total] in the control source on z60_num in test. This returns an error saying volsub does not exist as a form in the database.
I figure that I must be overlooking the obvious so thanks in advance. GGuy