Change object in another form?

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:

VB Code:

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

Try this

Code:

---

Private Sub Form_Load()

  Forms(frmGeopend).lblInventarisatie.visible = true

End Sub

Private Sub From_Unload()

  Forms(frmGeopend).lblInventarisatie.visible = false

End Sub

---

Another syntax style...

VB Code:

Forms![frmGeopend]![lblInventarisatie].Visible

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

I tried this:

VB Code:

Forms![frmGeopend]![lblInventarisatie].Visible

and this:

VB Code:

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?

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:

VB 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:

VB Code:

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

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