Make button not visible when TextBox in another form is NO

[Datament]

I have two forms:
1. frm_ACCT has txtPAY and a Checkbox Y/N that is checked ☑ (Y) whenever a payment received
2. frm_Recvd has a command button btn_PmtRecvd. Btn_PmtRecvd is visible when form opens. I want to make Btn_PmtRecvd not visible when or if frm_ACCT Checkbox isn't checked.

My code:
In the On Load event of frm_Recvd[COLOR=var(--highlight-keyword)]
if forms!frm_ACCT.Checkbox = -1 Then
Btn_PmtRecvd.Visible = True
Else
Btn_PmtRecvd .Visible =False
End If



I hope you can review and tell me what I am doing wrong. Every suggestion would be appreciated.[/COLOR]

[ArviLaanemets]

On fly a possible universal solution:
Have a global variable defined, which by default is False, and is reset True/False depending on value of checkbox in frm_ACCT;
The visibility of button Btn_PmtRecieved on frm_Recieved is defined by value of this global variable.

[moke123]

There's a few ways to do this but I don't think we know enough about your database.

The simplest way may be to pass the value using openargs and and use that value in the onload event to hide/show the control.

If frm_ACCT Checkbox is a bound field or there is some other field like payment date those can be used too, either as part of the forms source query or a dlookup.

[Welshgasman]

Just a simple test reply. Please ignore.