mary.stocks
New member
- Local time
- Today, 02:19
- Joined
- Apr 19, 2003
- Messages
- 5
Hi
any ideas on why this code doesnt work
Private Sub Quantity_AfterUpdate()
If [tblorder].[Quantity] <= [tblbale].[Quantity] Then
[tblbale].[Quantity] = [tblbale].[Quantity] - [tblorder].[Quantity]
End If
End Sub
I get Run-time error '2465';
MS Access can't find the field '|' referred to in your expression.
mary
any ideas on why this code doesnt work
Private Sub Quantity_AfterUpdate()
If [tblorder].[Quantity] <= [tblbale].[Quantity] Then
[tblbale].[Quantity] = [tblbale].[Quantity] - [tblorder].[Quantity]
End If
End Sub
I get Run-time error '2465';
MS Access can't find the field '|' referred to in your expression.
mary