Dlookup help

[jcaptchaos2]

Ok I am new here 1st post need help as I have been unsuccessful at my other board, I am trying to use Dlookup to add the "shift" to one of my tables, here is my code

=DLookUp("[Shift]","[employeelistingjac]","[EmployeeNumberr] = '" & [Forms]![Payroll_Time_on]![EmployeeNumber] & "'")

I get "#Name?" in the combo box.



Hope to get some help

Thanks JC

[pbaldy]

What is the data type of EmployeeNumberr in the table (and does the field really have 2 r's)?

[jcaptchaos2]

Thanks for responing, sorry I caught that after I posted her is my new code but still get the sane error and the the field is (number)

=DLookUp("[Shift]","[employeelistingjac]","[Employee Number]= '" & [Forms]![Payroll Time on]![Employee Number])

[pbaldy]

If it's a numeric field, you don't want that single quote before the value.

[jcaptchaos2]

That does not seem to make a difference

[pbaldy]

Can you post the db?

[jcaptchaos2]

How do I do that? I will do anything to get this working

[pbaldy]

Compact/repair and then zip, then attach in the advanced reply area using the Manage Attachments button.

[jcaptchaos2]

I found it, my form name was wrong, just needed a good night sleep and then to re-look at it, Thanks for your help

[jcaptchaos2]

Bot now have another question, it does bring the result up in the combo box that I want but then I get an error I think when it trys to send it to the table or an it says error in the combo box. I need the result to be placed in the shift column in the employee listingjac table

[jcaptchaos2]

Here is the DB

[pbaldy]

Which form? What are the steps to recreate the problem?

[jcaptchaos2]

Paroll time on form - I would like the shift which is the DLOOKUP to be stored in the Paroll time on table

Thank you

[pbaldy]

Ah; you want to take the DLookup out of the control source of that textbox and change it to the shift field. That binds the textbox to the table. In the after update event of the employee number textbox, set the value of the shift field with the same DLookup. It looks like you were trying to do that, but you have it in the after update event of the shift textbox.

[jcaptchaos2]

Ok thank you I will give that a try