Programmatically altered label not recognized in if statement

[newbieX]

On main menu form (MainForm), when user clicks a button it runs the following code, which opens a new form and changes the title(caption)- (displayed in a label in the header section).

DoCmd.OpenForm "Validate", acNormal
Forms!Validate.Lbl_BannerValidate.Caption = "Edit Data"

When the form opens, I want to check to see what the title is, and depending on the title, perform an action. The form opens and displays the correct title after running the above code ("Edit Data"), however, it is not recognizing the caption value correctly. Even though the caption correctly displays the programmatically altered caption, the below code only recognizes the default caption listed in the label's (Lbl_BannerValidate) property box.

Private Sub Form_Open(Cancel As Integer)
    DoCmd.Close acForm, "MainForm", acSaveNo

    If Me!Lbl_BannerValidate.Caption = "Validate Data" Then
        If Me!cmdSamples.Visible = "No" Then
             Me!cmdSamples.Visible = "Yes"
        End If
    End If
    If Me!Lbl_BannerValidate.Caption = "Edit Data" Then
        If Me!cmdSamples.Visible = "Yes" Then
            Me!cmdSamples.Visible = "No"
        End If
    End If

    Debug.Print Me!Lbl_BannerValidate.Caption
End Sub

Debug.Print returns the value "Validate Data" instead of "Edit Data".

How can I rewrite my code to recognize the new caption and execute the proper if statements when true?

Access 2007

[ranman256]

Does
Forms!Validate!Lbl_BannerValidate.Caption = "Edit Data"

make a difference?

forms!Validate ! not period

[newbieX]

No. Doesn't make a bit of difference.I did notice that when using Debug print statement in MainForm coding, the correct value is returned. Do I need to pass this value to the form that is being opened? If so, how?

[June7]

Information can be passed to a form with OpenArgs argument.

DoCmd.OpenForm "Validate", acNormal, , , , , "Edit Data"

Then refer to OpenArgs

If Me.OpenArgs = "Validate Data" Then

[ssanfu]

You have to look at when things happen.

1) Main form -> command -> DoCmd.OpenForm "Validate", acNormal

2) Form "Validate" opens
Form "Validate" Form_Open code executes -> caption is "Validate Data"
Form "Validate" Form_Open code completes

3) Now back to Main form -> command -> Forms!Validate.Lbl_BannerValidate.Caption = "Edit Data"

4) Form "Validate" Lbl_BannerValidate.Caption is now "Edit Data" ... but no code executes to set the button states.

I would use the OpenArgs argument as June suggests...