Access Tables from a Form for calculations

[JimMiller]

I am trying to access fields in a table from a Form's VBA code. I am having trouble with the syntax for accessing tables. Here is what I have coded so far:

If IsNull(

![Issues]![RevisedEstHours]) = False Then

![Issues]![RemainingHours] =

![Issues]![RevisedEstHours] - (DSum("[NumberHours]", "[IssueAllocation]", "NASIssueNumber = " & [Forms]![ProjectTrack]![NASIssueNumber]))
Else

![Issues]![RemainingHours] =

![Issues]![EstimatedHours] - (DSum("[NumberHours]", "[IssueAllocation]", "NASIssueNumber = " & [Forms]![ProjectTrack]![NASIssueNumber]))
End If

Anyone have any ideas why it is not working?