(Continued) Selective display of fields/buttons in a subform

  • Thread starter Thread starter RoBo
  • Start date Start date
R

RoBo

Who can give me a hand?

In a subform, displayed on a tab control, I would like to hide/show several
fields, based on the value of one of the fields in this subform. If the field
'Description' contains a specific value, some fields on the subform should be
hidden, as well as two buttons. With what event can I control this?

I am using Single Form view.

Thanks for all the help, Ron
 
In Single Form view, you could use the Current event of the form to set the
caption of the command button:

Private Sub Form_Current()
Me.Button1.Caption = Nz(Me![Description], vbNullString)
End Sub
 
Hello Allen,

Thanks for the info; I'll give it a try after my vacation.

Ron

Allen Browne said:
In Single Form view, you could use the Current event of the form to set the
caption of the command button:

Private Sub Form_Current()
Me.Button1.Caption = Nz(Me![Description], vbNullString)
End Sub

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

RoBo said:
Who can give me a hand?

In a subform, displayed on a tab control, I would like to hide/show
several
fields, based on the value of one of the fields in this subform. If the
field
'Description' contains a specific value, some fields on the subform should
be
hidden, as well as two buttons. With what event can I control this?

I am using Single Form view.
Click to expand...
Click to expand...
 
Back
Top