change a control from a subform or after openform command

[walterio]

Hi


How do I change a control from within a called subform? Or how do I return an argument to the calling form?

Ive tried in the subform with »Me.Parent!control«, »Me!Parent!control«, »Forms!Formname!control«. Nothing worked.

Then I tried getting the OpenArgs after the oppening with
»DoCommand.OpenForm "ufSubform", OpenArgs:=Params«,
but OpenArgs ist Null and Params contains only what it had before the open of the subform.

Thanks for your help

[Bob Fitz]

I don't understand what you are trying to do.

Are you trying to display on the main form a value (perhaps a total?) which is on the sub form?

[walterio]

yes. on the main form I have a label, which displays a text depending on a condition, which can be changed in the sub form.

[Bob Fitz]

Try something like:

Parent.LabelName.Caption = "Text to be Shown"

In the AfterUpdate event of the control on the sub form

[walterio]

This is the code:
Parent.Freigabestatus.Caption = "soso"
and it results in a runtime error 2452: The expression you entered has an invalid reference to the Parent property.

I also tried Parent.Freigabestatus!Caption an other combinations of . !

And I use in in the click Event of a command button, but I don't think that matters..

[Bob Fitz]

The error message is telling you that the form containing the control which is firing the code doesn't have a parent form. So, is the "subform" actually a subform control on the main form or is this "subform" just another form which was opened when the main form was opened.

If it is a proper sub form, I would suspect that something is corrupt. Perhaps you could post a copy of the db.

[walterio]

It is a sub form that opens with a command button.

[Bob Fitz]

It is a sub form that opens with a command button.

Then that is not a sub form.

So, code would be something like:

Forms!NameOfForm.LabelName.Caption = "Text to be Shown"

[walterio]

runtime error 2450 MS A cannot finr the referenced form ...
I'm calling this not-subform from a real sub form. May it be, that that is the problem?
I tried another way: this not-subform is called with some arguments in OpenArgs, so I tried tu use the same wys back. But this doesn't work, OpenArgs is Null.

[Bob Fitz]

runtime error 2450 MS A cannot finr the referenced form ...
I'm calling this not-subform from a real sub form. May it be, that that is the problem?
I tried another way: this not-subform is called with some arguments in OpenArgs, so I tried tu use the same wys back. But this doesn't work, OpenArgs is Null.

I don't understand.
Please post a copy of the db

[walterio]

ok, give me some minutes.
and by the way: thank you very much for your support.

[walterio]

I'm sorry, but the db is to big, although there is only 1 record in each File...
So I'm attaching only the modules of the 3 forms involved:

• ufAuftrags_Messungen, the sub Form which contains the command button involved in this drama
• ufMessung_Freigabe and ufMessung_Freigegeben, the two called forms, depending on the field "Freigegeben", both permit the swich from one state to the other...

Hope it's not "toooo much information!"

[walterio]

What do you think of my other approach: returning from the forms and thanks to an argument the settings for the Freigabestatus-Field could be defined. Only: how do I get the arguments from a called form?

[Bob Fitz]

I'm sorry, but the db is to big, although there is only 1 record in each File...
So I'm attaching only the modules of the 3 forms involved:

• ufAuftrags_Messungen, the sub Form which contains the command button involved in this drama
• ufMessung_Freigabe and ufMessung_Freigegeben, the two called forms, depending on the field "Freigegeben", both permit the swich from one state to the other...

Hope it's not "toooo much information!"

"Compact and Repair" the db and then compact it to a "Zip" file before trying to attach the db.

[walterio]

ok, but I have to postpone the matter for tomorrow? Thank you for your help, so far.