If DCount("[REG_NO]", "Tbl_Regn", "[REG_NO] =" & Me.Parent.[ID]) > 0 Then
Msgbox “Rec Exists”
Endif
The underlined statement is giving Runtime Error '2471'
The expr you entered as a query parameter produced this error: 'F'
Please guide me.
If DCount("[REG_NO]", "Tbl_Regn", "[REG_NO] =" & Me.Parent.[ID]) > 0 Then
Msgbox “Rec Exists”
Endif
The underlined statement is giving Runtime Error '2471'
The expr you entered as a query parameter produced this error: 'F'
Please guide me.
You could try
If DCount("[REG_NO]", "Tbl_Regn", "[REG_NO] = '" & Me.Parent.[ID] & "'") > 0 Then
Do you know what value Me.Parent.[ID] returns?
Have you saved the record before invoking the DCount?