Assistance in how to code in an Access form

[apbhrbl]

Hello everyone,
I'm new in the use of access and I was wondering how to code in visual basic the following request:

I'm trying to go to an specific tab in a form and if i put a value in tab "Refunded amount" I want to disable another tab in this case "7%refunded amount".

My coding look as follows:

Private Sub CRRefundedAmount_Enter()
If IsNull(Me.CRRefundedAmount.Value) Then
Me.7%CRRefundedAmount.Locked = False
End If
End Sub

I would really appreciate anyones' help

thanks

 

[RoyVidar]

What you refer to as "tab", are they form controls (text boxes) or pages on a tabl control?

If it's a text control, then to have somathing happen after something is entered, use the after update event of the control. And, here you're using special characters withing the control name, perhaps something like this (the [brackets]):

[tt]If IsNull(Me!CRRefundedAmount.Value) Then
Me![7%CRRefundedAmount].Locked = False
else
Me![7%CRRefundedAmount].Locked = true
End If[/tt]

- is this something along the lines you need?

BTW - Welcome to Tek-Tips!
To get the most out of the membership, have a look at this faq faq181-2886.

Good Luck!

Roy-Vidar