Need Help - Access Form

[Fandy]

Question:
Please I want to deactivate these fields (Trans Details, Service Rate, Quantity & Bill Amount) when PAYMENT is selected
from Trans Type Field. Can someone assist me to do in my form above?

 

[Gasman]

Set their enabled property to False in the AfterUpdate Event of the combo if it is Payment type?

 

[Fandy]

Set their enabled property to False in the AfterUpdate Event of the combo if it is Payment type?

can you help with the code statement please?

 

[Gasman]

If Me.TransType = 1 '<whatever the value of Payment is meant to be?> then
    Me.TransDetails.Enabled = False
Else
    Me.TransDetails.Enabled = True
End If

You will likely need similar code in the Current event of the form if you need it as you move through the records.?
Perhaps just call that event?

Another method might be

Me.TransDetails.Enabled = Me.TransType <> 1 '<whatever the value of Payment is meant to be?>

You can add the other controls in a similar manner.

 

[Fandy]

If Me.TransType = 1 '<whatever the value of Payment is meant to be?> then
    Me.TransDetails.Enabled = False
Else
    Me.TransDetails.Enabled = True
End If

You will likely need similar code in the Current event of the form if you need it as you move through the records.?
Perhaps just call that event?

Another method might be

Me.TransDetails.Enabled = Me.TransType <> 1 '<whatever the value of Payment is meant to be?>

You can add the other controls in a similar manner.

can you do it step by step for me please. I'm a baby in coding. I'm now learning it.

 

[Gasman]

So now woul be a good time to start.?
You will not get easier coding than this.?

Watch some videos, see link below

https://www.youtube.com/results?search_query=vba+code+access+form+events