Need help with Thread 702-1371288

[idavis1900]

This thread seems like something I could use but I don't understand where to put the code. Does it go on the beforeupdate on the form or the beforeupdate on the text box [CkAmount]

I believe this is the right code:
Me![CkAmount] = Me!Percent

my table is tblbill
my form is frmbill
on the form [percent] as a iff statment that I would like the result to be put in the bound text box [ckamount]

thank you for your help

 

[PHV]

Create a new text box bound to your new field and populate it in the [!]BeforeUpdate event procedure of the form[/!]:
Me![new control] = Me!Billable_Total

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[idavis1900]

PH,

This is what I think your telling me and it's not working

Private Sub Form_BeforeUpdate(Cancel As Integer)
Me![CkAmount] = Me!Percent
End Sub

What am I doing wrong

Irene

 

[PHV]

it's not working
Any chance you could elaborate ?

 

[idavis1900]

PH,

I figure what was wrong, I need to do a new record to see it work. Thank you for you help

 

[idavis1900]

PH,
This works great for one of my text boxes. But I have a second text box that has a if statment it it. Which is: =IIf([oon]=-1,[ckamount],0)

How do I change this code:
Me![CkAmount] = Me!Percent

To handle the if statment

Thank you,
Irene