Help !!!!! If, Then, Else Code in a form

[melonwand]

I'm using Access 2007 and I know enough to get me in trouble. I want to have a field in my form calculate based on 2 other fields that will be populated when data entered. The form is created from a Table not a Query. This is what I have and I'm not sure how to make it work or if it can work.

Private Sub Aud_Required_AfterUpdate()
If [ActTy] = "Consulting" Or [ActTy] = "Project Management" Then
BudgetConsultHrs = [ActivityHours] * [AudRequired]
Else
BudgetConsultHrs = (0)
End If


End Sub

I've been given a deadline to get this database done and this is seriously holding me back. I'd appreciate any help!

[RuralGuy]

Have you tried what you have? Does it work? If not, what does it do wrong?

[melonwand]

I did finally get it to work. I had to change the field names to start with Me.

[RuralGuy]

Great! Are you ready to use the Thread Tools and mark this thread as Solved?