change a control from a subform or after openform command

[walterio]

Hello, I'm back again.

The attached data base is an extract of the original, but contains all which is needed to understand my problem.

Please call the macro Auftragsverwaltung an give ks as Kundencode in the asking message. Then the form ufAuftragsverwaltung opens, with the sub form ufAuftrags_Proben , which contains the sub form ..._Mesblocks and this one contains ..._Messungen , which is the one with the command button cmdFreigabe and the label Freigabestatus on the right. This last control is the one I need to change (caption and color). Clicking on the command button opens one of the forms ufMessung_Freigabe and ...Freigegeben, depending on the state of the Yes/No field Freigegeben. This field is then changed by the called form.

What else? I'll wait for questions or comments.

[Bob Fitz]

I suspect that this db is being developed for German speaking users. Unfortunately I only understand English which, along with knowing nothing about what your db is for, is making this a rather difficult task.

From your last post:

....depending on the state of the Yes/No field Freigegeben....

Where can this "Yes/No field" be found please.

[walterio]

Freigegeben is in DAT03-Messungen

[walterio]

I'm sorry about the German...
These are measurements, which included in a block are used to produce a report. The measurements are provided for a sample as part of an assignment. And the report should only show data if the measurement has been given free (freigegeben).

But I doubt this will be of much help...

[Bob Fitz]

Freigegeben is in DAT03-Messungen

Is that shown on any open form/subform

[Bob Fitz]

I'm sorry about the German...
These are measurements, which included in a block are used to produce a report. The measurements are provided for a sample as part of an assignment. And the report should only show data if the measurement has been given free (freigegeben).

But I doubt this will be of much help...

No apology needed . Nobody's fault that it is in German. Just explaining my difficulty in helping. Your English in this post is excellent though .

[walterio]

The value of »Freigegeben« is shown indirectly by the caption and forecolor of the label »Freigabestatus«, which are set in the form event OnCurrent of the form »ufAuftrags_Messungen«. This Form displays the records of »DAT03-Messungen«, where the field is defined.

[Bob Fitz]

In post #5 you said:

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..

If you use the line:

Me.Freigabestatus.Caption = "soso"

there is no error and the caption used in Freigabestatus does change to "soso".

Does this help?

[walterio]

The label Freigabestatus is in the form ufAuftrag_Messungen.
To change it, depending on the action taken by the user in the called forms ufMessung*, I should be able to receive a message of the called form: user-did-change-the-status or nothing. Something equivalent to OpenArgs...

[walterio]

My attempt with Parent.Freigabestatus.Caption = "soso" was intended to be used in the called form, which I now understand is not a sub form and therefore could not work.

[Bob Fitz]

Have you considered declaring a variable in your module called "Aufgabenaufrufe" perhaps "Public blnFromForm As Boolean".

This could then be set a value before opening either form in the button's On Click event and the value of the variable could be reset if appropriate before each form is closed.

[walterio]

That is very clever!
But in the calling sub form, where do I position the "asking" after I opened one of the forms?
The forms get opened in a procedure from the click event on the command button "Freigabe". I will see, if blnFromForm is changed immediately after the open command.
... (few minutes later)
No, it didn't work. While debugging step by step, I noticed that after the open command the next step was still on the calling form. The called one waited until the procedure was ended...

[Bob Fitz]

That is very clever!
But in the calling sub form, where do I position the "asking" after I opened one of the forms?
The forms get opened in a procedure from the click event on the command button "Freigabe". I will see, if blnFromForm is changed immediately after the open command.
... (few minutes later)
No, it didn't work. While debugging step by step, I noticed that after the open command the next step was still on the calling form. The called one waited until the procedure was ended...

Sorry, forgot to say that the two forms opened from the button need to be opened in Dialog mode which stops the button code from running until the opened form is closed.

[walterio]

Yes! That was it, what I was looking for. Thank you very much.

[Bob Fitz]

Yes! That was it, what I was looking for. Thank you very much.

Your welcome. Only sorry that it took me so long to fully understand the requirement.
BTY thank you for your kind words left in the reputation comments. If you're ever near my part of the world (Essex in England) send me a private message. Always glad to make a new acquaintance