Syntax to refer to subform control

  • Thread starter Thread starter CJ
  • Start date Start date
C

CJ

Hi groupies

I am trying to make a label on a subform disappear but I can not get the
syntax correct.
I have tried many variations but this is what I have at the moment. Needless
to say, nothing happens.

<snip>
If txtPassword = strPassword Then
DoCmd.Close

' start area of trouble
Set frmJobMlt = Screen.ActiveForm

Forms![frmJobMlt]![fsubMLT].Form![lblCompleted].Visible = False
Forms!frmJobMlt.Repaint
'end area of trouble
<snip>

Can somebody please correct it for me?
 
Ciao "CJ said:
Hi groupies

I am trying to make a label on a subform disappear but I can not get the
syntax correct.
I have tried many variations but this is what I have at the moment.
Needless to say, nothing happens.

<snip>
If txtPassword = strPassword Then
DoCmd.Close

' start area of trouble
Set frmJobMlt = Screen.ActiveForm
Click to expand...

Forms![frmJobMlt].[fsubMLT].Form.[lblCompleted].Visible = False
 
geppo said:
Ciao "CJ said:
Hi groupies

I am trying to make a label on a subform disappear but I can not get the
syntax correct.
I have tried many variations but this is what I have at the moment.
Needless to say, nothing happens.

<snip>
If txtPassword = strPassword Then
DoCmd.Close

' start area of trouble
Set frmJobMlt = Screen.ActiveForm
Click to expand...

Forms![frmJobMlt].[fsubMLT].Form.[lblCompleted].Visible = False

Forms!frmJobMlt.Repaint
'end area of trouble
<snip>

Can somebody please correct it for me?
Click to expand...
Click to expand...

Got it. Thanks a bunch!!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Reference Subform's Control 0
Validation of subform 16
Focus to SubForm Control 10
How to always get the top level form reference, when calling from any subform/subform... 0
setfocus to control in visible subform 3
Cannot Get ListBox .ItemsSelected, help! 1
Subforms linked to subforms 2
Copy data from 1 subform to another subform 2

Back
Top