Command Button to Unhide Fields

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sunilkeswani@gmail.com - 30 Oct 2005 08:49 GMT

Hi

How do I make a command button which would make some form fields
visible when clicked? Or maybe those fields could pop up on another
form

Sunil

Reply to this Message

Bernard Peek - 30 Oct 2005 15:31 GMT

>Hi
>
[quoted text clipped - 3 lines]
>
>Sunil

Try something like this:

sub Showme_Click

ctrl1.visible = not ctrl1.visible
ctrl2.visible = not ctrl2.visible

end sub

Signature

Bernard Peek
London, UK. DBA, Manager, Trainer & Author.

Reply to this Message

Ted - 30 Oct 2005 20:58 GMT

Sunil:
Here is another option. If the fields need to be visible based upon the
value of a particular field, then you could use code similar to this:

AfterUpdate Event for FieldNameA
If Me!FieldNameA > 500 Then
Me!FieldNameB.Visible = True
Else
Me!FieldNameB.Visible = False
End If

I hope this is helpful.
Ted

Reply to this Message

sunilkeswani@gmail.com - 31 Oct 2005 20:41 GMT

Thanks for the inputs ! This really helps.

Reply to this Message