jaxflorida
Technical User
Hi,
I am a only an occasional user to programming in Access so I really don't know much about the code area. I have been banging my head against the wall for some time now. This code was modified from a totally different database.
I have a form that has a calcuation in its code shown here:
Private Sub CurrentWorkforce_AfterUpdate()
Function EMFCalc(currentworkforce As Integer) As Single
Select Case currentworkforce
Case 1 To 50
EMFCalc = 1
Case 51 To 100
EMFCalc = 1.25
.
.
.
Case Is >= 1001
EMFCalc = 999
End Select
End Function
This form is based on a table named SER1. I need the calucation to update a field called EMF in my table after someone enters data in my form field called currentworkforce. I have seen reference to something similar in the FAQ, but they were doing a simple calculation within the expression builder.
I would really appreciate any help that anyone could offer.
Thanks
I am a only an occasional user to programming in Access so I really don't know much about the code area. I have been banging my head against the wall for some time now. This code was modified from a totally different database.
I have a form that has a calcuation in its code shown here:
Private Sub CurrentWorkforce_AfterUpdate()
Function EMFCalc(currentworkforce As Integer) As Single
Select Case currentworkforce
Case 1 To 50
EMFCalc = 1
Case 51 To 100
EMFCalc = 1.25
.
.
.
Case Is >= 1001
EMFCalc = 999
End Select
End Function
This form is based on a table named SER1. I need the calucation to update a field called EMF in my table after someone enters data in my form field called currentworkforce. I have seen reference to something similar in the FAQ, but they were doing a simple calculation within the expression builder.
I would really appreciate any help that anyone could offer.
Thanks