Permanent Data

[louisa]

Hi everyone,

I have a form called "Commission" in that form are two fields one called "Invoiced" and another "TelesalesCommission"
The Invoiced field will have a date entered in to it, what i am hoping for is if the Invoiced field has data entered in it then the TelesalesCommission field should have £40.00 entered into it automatically. Does anybody no if this can be done?

 

[JamesMcS]

Hi Louisa! Yep that should be doable in VBA - depending on when you want the £40 added, all you have to do is use an if in the appropriate event:

if me.invoiced is not null then
me.telesalescomission.value=40
Else
me.telesalescommision.value=0
Endif

 

[louisa]

Hi James,

Thanks for coming back to me, i keep receiving Run Time Error 424 With "If Me.Invoiced Is Not Null Then" highlighted???

I have tried this in the Forms on load event and the fields on click event and after update :-(

 

[JamesMcS]

Ah that's an object required. Is the control called "Invoiced"? And is the event you've put the code in on the same form as "Invoiced" and "Telesalescommission"?

It might also be because of the is not null. Try changing that to <>""

 

[JANR]

Is Null is a SQL syntax use IsNull for VBA

So

Private Sub Invoiced_AfterUpdate()
If Not IsNull(Me.Invoiced) Then
   .....
End If
End Sub

JR

 

[JamesMcS]

Cheers Janr!

 

[louisa]

Thanks James, works brilliantly.

 

[JamesMcS]

Nyet problemski. Have a good one!