caykamanj1966
Technical User
I have a continuous form.
When that form is opened, I have the following code on the "OnLoad" event:
I don't want those objects to show when the form is opened and yes I know I have to rename the command button
Then on each record on the continuous form I have the below items, which you will notice some on the "OnCurrent" event:
chk_yesHyper
paste_hyperlink
Command88
So if I check the box for chk_yesHyper, then I want paste_hyperlink and Command88 to be visible, but if chk_yesHyper is not checked, then I want paste_hyperlink and Command88 to be invisible. The below is the code on chk_yesHyper "AfterUpdate" event:
The code above works well, but the only problem is if I check or uncheck yes_hyper, then does the action for all the records.
I just want it to do this on the current record I am working on. I do not want it to show the action I take for all records.
Can someone help me with this?
Thanks in advance!
When that form is opened, I have the following code on the "OnLoad" event:
Code:
Me.paste_hyperlinkNow.Visible = False
Me.Command88.Visible = False
I don't want those objects to show when the form is opened and yes I know I have to rename the command button
Then on each record on the continuous form I have the below items, which you will notice some on the "OnCurrent" event:
chk_yesHyper
paste_hyperlink
Command88
So if I check the box for chk_yesHyper, then I want paste_hyperlink and Command88 to be visible, but if chk_yesHyper is not checked, then I want paste_hyperlink and Command88 to be invisible. The below is the code on chk_yesHyper "AfterUpdate" event:
Code:
If Me.yes_hyper.Value = True Then
Me.paste_hyperlinkNow.Visible = True
Me.Command88.Visible = True
Else
If Me.yes_hyper.Value = False Then
Me.paste_hyperlinkNow.Visible = False
Me.Command88.Visible = False
End If
The code above works well, but the only problem is if I check or uncheck yes_hyper, then does the action for all the records.
I just want it to do this on the current record I am working on. I do not want it to show the action I take for all records.
Can someone help me with this?
Thanks in advance!