dlookup assistance

[underscore]

dear experts,

i have some trouble using dlookup in access. i need to have the information in table into form. how can i solve this please.

my form contains the following fields:
Empl num, emp nam, job title, job lev, cost, dept.

in my form, once i put 10000 (ex: Empl num) the rest of the fields will have the information from my table.

how can i do it please.



appreciated your help.

[RuralGuy]

Have you tried using the ComboBox wizard for the [Empl num] control and selecting option #3?

[underscore]

Have you tried using the ComboBox wizard for the [Empl num] control and selecting option #3?

Thank you Sir for your reply,

I have tried the ComboBox by using number 1 to get the value in other table.


The requirement is, once i enter the value in Empl num, the rest of the field will automatically filled with the information from other table.

If your suggestion is better than using dlookup, please guide me how to have it work.

thank you so much

[RuralGuy]

You should really base your form on a query of the two tables and only have the EmployeeNumber in this table. The values should *only* be in one table except for a ForeignKey.

[underscore]

Thank you Sir, I will try to create new table with your recommendations.

best regards,