Hide/Show fields at Form based on checkbox

[cap.zadi]

Hi Every One

I am looking forward to apply the code to hide/show up the fields at a form based on the click (Yes) at the Yes/No check box field.

There are many fields at the form but we will discuss here the relevant ones:

CustomerReturns (Yes/No)
CustomerName
CustomerProject

If i click at "CustomerReturns" as (Say Yes) then other two fields must show up else hidden.



Kindly advise the needful.

[pbaldy]

Does this help?

http://www.baldyweb.com/ConditionalVisibility.htm

[cap.zadi]

Hi, Thanks.

I find this code which works perfect while fixing at after-update and at click events.

Private Sub CustomerReturns_Click()


Me.CustomerName.Visible = (Me.CustomerReturns = True)
Me.CustomerProject.Visible = (Me.CustomerReturns = True)

End Sub

[pbaldy]

Yes, that uses Boolean logic to do the same thing, but many people don't understand it.

[cap.zadi]

Hi, Thanks

Can you check my another thread please.

https://www.accessforums.net/showthread.php?t=59368

[cap.zadi]

Hello Boss

I noticed that this Boolean logic works perfect only when form is uploaded for the new transaction otherwise the both hidden fields remains visible during next transactions until the form is closed and again opened for the new transaction.

Kindly advise.

[pbaldy]

Did you read the link, about the current event?

[cap.zadi]

Well, yeah i read it but dont understand how to apply this code from my perspective. Can you advise according my data details.

[nhorton79]

What pbaldy was trying to point you to was to put the code in the 'current' form event which triggers when a form changes record.

See this link to clarify the current event for a form:
https://msdn.microsoft.com/en-us/lib.../ff193159.aspx



Sent from my iPhone using Tapatalk