value from one subform to another subform

[Miran]

Hello!

I have on a form many subforms. I wolud like to get a value from one subform
to another subform. In the first subform in the Control Source I have choosen
a value from second subform. But when I go to the View of main form I get a
blank value. If I try to get the same value from second subform on a main
form by choosing that value on Control Source the system works fine.
Any ideas?

Miran

 

[Ofer Cohen]

How did you refer to that text box that you want to get the value from?

Forms![MainForm]![Sub From1 control name].Form![Text Box Name]

 

[Miran]

Thanks, but I`ve allready written that. On the main form it works, but on the
second subform it doesn`t.

I`ve on the first subform many records and one that displays max value of
that records. I would like to get that max value on the second subform.

Miran


"Ofer Cohen" je napisal:

How did you refer to that text box that you want to get the value from?

Forms![MainForm]![Sub From1 control name].Form![Text Box Name]

--
Good Luck
BS"D

Hello!

I have on a form many subforms. I wolud like to get a value from one subform
to another subform. In the first subform in the Control Source I have choosen
a value from second subform. But when I go to the View of main form I get a
blank value. If I try to get the same value from second subform on a main
form by choosing that value on Control Source the system works fine.
Any ideas?

Miran

 

[Miran]

Yes, it works, but I when I change the value on the first subform I have to
close the form and then again open it to refresh the second subform. I would
like that the second subform be refreshed every time when I change the walue
on the first subform without reopen the main form.

I`he noticed that the value on the main form refresh as soon as I change the
value on the first subform.

Solution?
Miran



"Miran" je napisal:

Thanks, but I`ve allready written that. On the main form it works, but on the
second subform it doesn`t.

I`ve on the first subform many records and one that displays max value of
that records. I would like to get that max value on the second subform.

Miran


"Ofer Cohen" je napisal:

How did you refer to that text box that you want to get the value from?

Forms![MainForm]![Sub From1 control name].Form![Text Box Name]

--
Good Luck
BS"D

Hello!

I have on a form many subforms. I wolud like to get a value from one subform
to another subform. In the first subform in the Control Source I have choosen
a value from second subform. But when I go to the View of main form I get a
blank value. If I try to get the same value from second subform on a main
form by choosing that value on Control Source the system works fine.
Any ideas?

Miran

 

[Ofer Cohen]

On the After Update evet of the relevant text box in the first sub form you
can refresh the second subform or the text box within it

Me.Parent[SecondSubFormControlName].Requery

Or
Me.Parent[SecondSubFormControlName].Form![TextBoxName].Requery

--
Good Luck
BS"D

Yes, it works, but I when I change the value on the first subform I have to
close the form and then again open it to refresh the second subform. I would
like that the second subform be refreshed every time when I change the walue
on the first subform without reopen the main form.

I`he noticed that the value on the main form refresh as soon as I change the
value on the first subform.

Solution?
Miran



"Miran" je napisal:

Thanks, but I`ve allready written that. On the main form it works, but on the
second subform it doesn`t.

I`ve on the first subform many records and one that displays max value of
that records. I would like to get that max value on the second subform.

Miran


"Ofer Cohen" je napisal:

How did you refer to that text box that you want to get the value from?

Forms![MainForm]![Sub From1 control name].Form![Text Box Name]

--
Good Luck
BS"D


:

Hello!

I have on a form many subforms. I wolud like to get a value from one subform
to another subform. In the first subform in the Control Source I have choosen
a value from second subform. But when I go to the View of main form I get a
blank value. If I try to get the same value from second subform on a main
form by choosing that value on Control Source the system works fine.
Any ideas?

Miran

 

[Ofer Cohen]

Sorry, I forgot the . After the Parent

On the After Update evet of the relevant text box in the first sub form you
can refresh the second subform or the text box within it

Me.Parent.[SecondSubFormControlName].Requery

Or
Me.Parent.[SecondSubFormControlName].Form![TextBoxName].Requery

--
Good Luck
BS"D

Yes, it works, but I when I change the value on the first subform I have to
close the form and then again open it to refresh the second subform. I would
like that the second subform be refreshed every time when I change the walue
on the first subform without reopen the main form.

I`he noticed that the value on the main form refresh as soon as I change the
value on the first subform.

Solution?
Miran



"Miran" je napisal:

Thanks, but I`ve allready written that. On the main form it works, but on the
second subform it doesn`t.

I`ve on the first subform many records and one that displays max value of
that records. I would like to get that max value on the second subform.

Miran


"Ofer Cohen" je napisal:

How did you refer to that text box that you want to get the value from?

Forms![MainForm]![Sub From1 control name].Form![Text Box Name]

--
Good Luck
BS"D


:

Hello!

I have on a form many subforms. I wolud like to get a value from one subform
to another subform. In the first subform in the Control Source I have choosen
a value from second subform. But when I go to the View of main form I get a
blank value. If I try to get the same value from second subform on a main
form by choosing that value on Control Source the system works fine.
Any ideas?

Miran