Thanks for ya help.
private Sub Member_id_AfterUpdate()
Dim LTotal As Long
LTotal = DCount("Member_id", "tblloan", "[Member_id] = " & Me.Member_Id & " And [returned_date] is null ")
MsgBox (LTotal)
This is my current code. It is returning error message:-
runtime error 3464
data...