This is my DLO0KUP Query
Me.BalanceA = DLookup("Balance", "CardDetails", "CardNo='" & Me.Combo60 & "'")
When I add this to Combo Box It work and show the result in the form field. But When I Add this to my Submit button it doesn't Work?
Why is it?
Me.BalanceA = DLookup("Balance", "CardDetails", "CardNo='" & Me.Combo60 & "'")
When I add this to Combo Box It work and show the result in the form field. But When I Add this to my Submit button it doesn't Work?
Why is it?