Hi Everyone.
I am trying to pull information of [Employees_table] based on [Emp_ID] on access 2010 form i have created combo box for [Emp_ID] and named as "Emp_IDcombo" on form i have several fields from tables and queries to be pulled on form's text box fields however, i have following problem with my first attempt "EmployeeNametxt" text box on my form to pull it from [Employees_table]'s "EmployeeName".
I manage to write this expression on control source of combo box =DLookUp("[EmployeeNametxt]","Employees_table","Emp_ID=' " & [me].[Emp_IDCombo] & " ' ") but unable to get correct result and it is showing #Name? error.
My [Emp_ID] field in [Employees_table] is Text field and [EmployeeName] is also text field in table.
Please can anyone help to fix this please.
thanks & regards,
MBA
I am trying to pull information of [Employees_table] based on [Emp_ID] on access 2010 form i have created combo box for [Emp_ID] and named as "Emp_IDcombo" on form i have several fields from tables and queries to be pulled on form's text box fields however, i have following problem with my first attempt "EmployeeNametxt" text box on my form to pull it from [Employees_table]'s "EmployeeName".
I manage to write this expression on control source of combo box =DLookUp("[EmployeeNametxt]","Employees_table","Emp_ID=' " & [me].[Emp_IDCombo] & " ' ") but unable to get correct result and it is showing #Name? error.
My [Emp_ID] field in [Employees_table] is Text field and [EmployeeName] is also text field in table.
Please can anyone help to fix this please.
thanks & regards,
MBA