Hello,
Table Name: tblDAO
Form Name: Task Details
Inside the form, i have a ComboBox & TextBox
ComboBox Name: cb_DAO_Task
TextBox Name: tb_DAODesc_Task
I added the following code on the AfterUpdate event:
Me.tb_DAODesc_Task = DLookup("DAODescription", ”tblDAO”, "DAO=" & Me.cb_DAO_task)
The reason is that i want to bring from the table (tblDAO) a value that match what I chose in the ComboBox to place it in the TextBox
the issue is that i am receiving error 2428 and other errors without knowing the reson.
Can you help me?
NB. i tried the following code also and having the same problem:
Me.tb_DAODesc_Task = DLookup("[DAODescription]", ”tblDAO”, "[DAO]=" & Me.cb_DAO_task)