Hello,

I'm trying to enter the following code in a form but its not working the way 
I want it.  This is what i'm trying to accomplish.  The 
btnContinuePaymentValidation runs a macro that takes the user to a different 
form once the user is done entering the data on the form.  However, I only 
want the button to appear when txtPayAmtTotal = txtCheckAmountTotal.  
Othwerwise the suer will continue without balancing for the day.

Private Sub Form_Dirty(Cancel As Integer)
If Me.txtPayAmtTotal = Me.txtCheckAmountTotal Then
    Me.btnContinuePaymentValidation.Visible = True
Else
Me.btnContinuePaymentValidation.Visible = False
End If

Any feedback will be appreciated...

Thank You

You can put code in the after update event of every updateable control like 
this:

 If Me.txtPayAmtTotal = Me.txtCheckAmountTotal Then
    Me.btnContinuePaymentValidation.Visible = True
 Else
    Me.btnContinuePaymentValidation.Visible = False
 End If



Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia




"Joe" <Joe@discussions.microsoft.com> wrote in message 
news:205995E7-66D0-4FF7-AF76-1725D390BC4C@microsoft.com...
> Hello,
>
> I'm trying to enter the following code in a form but its not working the 
> way
> I want it.  This is what i'm trying to accomplish.  The
> btnContinuePaymentValidation runs a macro that takes the user to a 
> different
> form once the user is done entering the data on the form.  However, I only
> want the button to appear when txtPayAmtTotal = txtCheckAmountTotal.
> Othwerwise the suer will continue without balancing for the day.
>
> Private Sub Form_Dirty(Cancel As Integer)
> If Me.txtPayAmtTotal = Me.txtCheckAmountTotal Then
>    Me.btnContinuePaymentValidation.Visible = True
> Else
> Me.btnContinuePaymentValidation.Visible = False
> End If
>
> Any feedback will be appreciated...
>
> Thank You 

Even simpler:
Me.btnContinuePaymentValidation.Visible = (Me.txtPayAmtTotal = 
Me.txtCheckAmountTotal)
-TedMi

"Jeanette Cunningham" <nnn@discussions.microsoft.com> wrote in message 
news:efRIk5iyKHA.2436@TK2MSFTNGP04.phx.gbl...
> You can put code in the after update event of every updateable control 
> like this:
>
> If Me.txtPayAmtTotal = Me.txtCheckAmountTotal Then
>    Me.btnContinuePaymentValidation.Visible = True
> Else
>    Me.btnContinuePaymentValidation.Visible = False
> End If
>
>
>
> Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
>
>
>
>
> "Joe" <Joe@discussions.microsoft.com> wrote in message 
> news:205995E7-66D0-4FF7-AF76-1725D390BC4C@microsoft.com...
>> Hello,
>>
>> I'm trying to enter the following code in a form but its not working the 
>> way
>> I want it.  This is what i'm trying to accomplish.  The
>> btnContinuePaymentValidation runs a macro that takes the user to a 
>> different
>> form once the user is done entering the data on the form.  However, I 
>> only
>> want the button to appear when txtPayAmtTotal = txtCheckAmountTotal.
>> Othwerwise the suer will continue without balancing for the day.
>>
>> Private Sub Form_Dirty(Cancel As Integer)
>> If Me.txtPayAmtTotal = Me.txtCheckAmountTotal Then
>>    Me.btnContinuePaymentValidation.Visible = True
>> Else
>> Me.btnContinuePaymentValidation.Visible = False
>> End If
>>
>> Any feedback will be appreciated...
>>
>> Thank You
>
>