Search results

Thank you!! It works for me Please It works for me!!! Thank you for your fast response!! Please see the codes Private Sub cboEmp_Click() Me.cboEmp = DLookup("[ID]", "tbl_EMPMAIN", "[ID]=" & Me.cboEmp) Me.txtName = DLookup("[EMPNAME]", "tbl_EMPMAIN", "[ID]=" & Me.cboEmp) End Sub Private Sub...

Thank you very much! Does DCount facilitate to check duplicate value with in two fields of a single table? Because EMP NO and EMP Name are interrelated entries.There for I want to check these two fields together.

I need to know,Is it possible to use DLookup with And condition? Because I tried folowing vba code in my Access database which gave me a Data Type Mismatch Error.The code used myself is as follows; Dim EMP As Long 'EMP = DLookup("[ID]", "tbl_Test", "[ID] = '" & Me.txtEmpNo & "' And EMPNAME = "...