hi
i am using the Codes below bot result is Zero
Actually I want the user to get the number of Books available in the Library with the same title when select a particular book from the ComboBox "COMT"
Val = DCount("[Title]", "[BOOK]", "[Title] = " & "'" & Forms!FrmBook!COMT & "'")
i am using the Codes below bot result is Zero
Actually I want the user to get the number of Books available in the Library with the same title when select a particular book from the ComboBox "COMT"
Val = DCount("[Title]", "[BOOK]", "[Title] = " & "'" & Forms!FrmBook!COMT & "'")