Show a button in FormA based on an TXT_field in FormB

[terjeo]

Hello all helpers.
I am trying to learn VBA.

I have two forms, one FormA and one FormB.
In FormA I have a button "Other_info"


In FormB I have a txt_field "Other Info".

When something is written in the txt_field in FormB, I want the button "Other_info" to be visible in FormA. Els not.

This is my code:

If Len(Me.[Other Info].Value & "") > 0 Then
Forms!FormA!Other_Info.Visible = True
'Else
'Forms!FormA!Other_Info.Visible = False

'End If

This do not work.
I get a message that the system do not find "FormA"

I am grateful for any tip.

[davegri]

Both FormA and FormB must be open when txt_field is evaluated in FormB.

[terjeo]

davegri

I do not understand this.

When I write in the Text field in FormB, must the FormA be open?

Sorry for my stupidity

[davegri]

When I write in the Text field in FormB, must the FormA be open?

Yes. FormB cannot find FormA unless it is open. This is exactly what is triggering your error message.

[terjeo]

Yes. FormB cannot find FormA unless it is open. This is exactly what is triggering your error message.

Ok, so I can not use this metod, but thanks anyway, I have learned some more

[davegri]

Ok, so I can not use this metod, but thanks anyway, I have learned some more

Perhaps there are workarounds. You can store the value of txt_field in a Tempvar whenever it is updated.
Then, whenever FormA is opened at a later time, it can look at the Tempvar for a value.
This will only work for the current session, as the values of Tempvars are not retained after shutdown.