combo DLookUp() Function

[sbetancourt]

Hi,

I am making a database that will look up an employee in the main form and in the subform I can see their tasks. The subform is in a datasheet view and it has a combo box that allows you to select the task and then the adjacent text boxs fill up using the DLookUp function. I can't seem to make the DLookUp code work. I have

=DLookUP ("Field", "Table")

What else does this code need to work?

Any help is appreciated. Thank you in advance.

-Susana

[puppydogbuddy]

Hi,

I am making a database that will look up an employee in the main form and in the subform I can see their tasks. The subform is in a datasheet view and it has a combo box that allows you to select the task and then the adjacent text boxs fill up using the DLookUp function. I can't seem to make the DLookUp code work. I have

=DLookUP ("Field", "Table")

What else does this code need to work?

Any help is appreciated. Thank you in advance.

-Susana

If you are looking up tasks for a specific employee, you forgot the where clause which will enable you to find the tasks for the employee whose SSN you selected from your combo box:

If SSN is text:
=DLookUP ("[TaskField]", "EmployeeTaskTable", "[SSN] = '" & Me!cboSSN & "'")

If SSN is numeric:
=DLookUP ("[TaskField]", "EmployeeTaskTable", "[SSN] = " & Me!cboSSN)

[sbetancourt]

If you are looking up tasks for a specific employee, you forgot the where clause which will enable you to find the tasks for the employee whose SSN you selected from your combo box:

If SSN is text:
=DLookUP ("[TaskField]", "EmployeeTaskTable", "[SSN] = '" & Me!cboSSN & "'")

If SSN is numeric:
=DLookUP ("[TaskField]", "EmployeeTaskTable", "[SSN] = " & Me!cboSSN)

Thanks for the help. I tried your suggestion but it is still not working. I am placing this in the control source field of the text box; is this the correct place for it? This is what I put:

The field is text so I used your first suggestion:
=DLookUp("[ReferenceMaterial]","tblTopic","[Topic] = '" & [Me]![cboTopic] & "'")

[puppydogbuddy]

Thanks for the help. I tried your suggestion but it is still not working. I am placing this in the control source field of the text box; is this the correct place for it? This is what I put:

The field is text so I used your first suggestion:
=DLookUp("[ReferenceMaterial]","tblTopic","[Topic] = '" & [Me]![cboTopic] & "'")

If you have a textbox, then you need to replace [Me]![cboTopic] with Me![YourTextboxName]....using the actual name of your textbox. I had assumed you had a combobox named cboTopic.