Change object in another form?

[bubani]

Hello there,

In Access i have made several forms. But there is one form that stays on the foreground all the time, called frmGeopend. On that form i have a label, called lblInventarisatie. That label is invisible. Now i want that label to be visible as soon as i opened the form frmInventarisatie. And when i close lblInventarisatie the label on frmGeopend must be invisible again. I tried te follow code:

frmInventarisatie:

Private Sub Form_Load()
Form_frmGeopend.lblInventarisatie.visible = true
 
End Sub
 
Private Sub Form_unLoad()
Form_rmGeopend.lblInventarisatie.visible = false

Too bad that this code doesn't work

does somenody know how to solve this problem.

thanx

Bubani

[ekbranson]

Try this

Private Sub Form_Load()

  Forms(frmGeopend).lblInventarisatie.visible = true

End Sub

Private Sub From_Unload()

  Forms(frmGeopend).lblInventarisatie.visible = false

End Sub

[RobDog888]

Another syntax style...

Forms![frmGeopend]![lblInventarisatie].Visible

[bubani]

Hey there thanks for your reply's but they still don't work.

I tried this:

Forms![frmGeopend]![lblInventarisatie].Visible

and this:

Private Sub Form_Load()
 
  Forms(frmGeopend).lblInventarisatie.visible = true
 
End Sub
 
Private Sub From_Unload()
 
  Forms(frmGeopend).lblInventarisatie.visible = false
 
End Sub

but neither the 1st or the 2nd worked. I'm very sad about it, maybe there is another way to do this?
Or could it be some settings?

[alex_read]

The following code works fine for me, it may be that the event you're placing the code in isn't being fired.

Create a new access database & create 2 forms.

Form1 should have a button & a label, & the button should have this code:

Private Sub Command1_Click()
    DoCmd.OpenForm "Form2"
    Me.Label1.Visible = True
End Sub

Form2 should just be blank or have a standard label on. The form's code should contain this:

Private Sub Form_Unload(Cancel As Integer)
    Forms!Form1!Label1.Visible = False
End Sub

[RobDog888]

The order of operations for a form are:

Loading:
1.) Form_Open
2.) Form_Load
3.) Form_Resize
4.) Form_Acitvate
5.) Form_Current

Unloading:
1.) Form_Unload
2.) Form_Close

Maybe you may have some code in an event that fires after the
Form_Load event changing the label visibility to false after you
had changed it to true?

HTH