Infinite calculating -- "externally" linked subforms

  • Thread starter Thread starter F W Levy
  • Start date Start date
F

F W Levy

Greetings. I have a couple of subforms that I've linked "externally"
(i.e., not as traditionally embedded form/subform, but by creating a
calculated field outside of the primary subform (e.g., =[primary
subform].[ID])) then linking a second subform to that calculated field in a
parent/child relationship. For the most part, this scheme works and allows
me more interface design flexibility.

One problem, however, is that in one of these set-ups -- in the second
subform -- I have tried to include an unbounded calculated field, which
simply sums up two other fields within that same second subform. (i.e., In
subform #2: Field 3: = [field 1] + [field 2]). When I enter this
calculation, the field will complete the calculation, but enter into an
infinite loop of calculating, which ties everything up.

Though the calculation components all reside in the second subform, I
suspect this has something to do with my 'external link' set up -- as I also
occassionally run into a similar problem regarding cursor placement, i.e.,
when I move my cursor from the primary subform to some field in the second
subform, that second subform will "calculate" and bump my cursor to the
first field in that second subform. After that initial undesired
repositioning, I can however move the cursor to my originally intended
field, and there is no problem.

Any thoughts?

Thanks!
Farron
 
Doubt its tied to the linked forms. In what event are you doing the
calculation ? You will get a loop if you put this in the form Current
event, for ( maybe ) obvious reasons.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
 
Thanks for the reply -- I'm not doing the calculation in an event. I put "=
[field 1] + [field 2]" in the control source field.

Adrian Jansen said:
Doubt its tied to the linked forms. In what event are you doing the
calculation ? You will get a loop if you put this in the form Current
event, for ( maybe ) obvious reasons.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
F W Levy said:
Greetings. I have a couple of subforms that I've linked "externally"
(i.e., not as traditionally embedded form/subform, but by creating a
calculated field outside of the primary subform (e.g., =[primary
subform].[ID])) then linking a second subform to that calculated field
Click to expand...
in
a
parent/child relationship. For the most part, this scheme works and allows
me more interface design flexibility.

One problem, however, is that in one of these set-ups -- in the second
subform -- I have tried to include an unbounded calculated field, which
simply sums up two other fields within that same second subform. (i.e., In
subform #2: Field 3: = [field 1] + [field 2]). When I enter this
calculation, the field will complete the calculation, but enter into an
infinite loop of calculating, which ties everything up.

Though the calculation components all reside in the second subform, I
suspect this has something to do with my 'external link' set up -- as I also
occassionally run into a similar problem regarding cursor placement, i.e.,
when I move my cursor from the primary subform to some field in the second
subform, that second subform will "calculate" and bump my cursor to the
first field in that second subform. After that initial undesired
repositioning, I can however move the cursor to my originally intended
field, and there is no problem.

Any thoughts?

Thanks!
Farron
Click to expand...
Click to expand...
 
Back
Top