Form fields based on table data

[mborg]

I have the following structure:
Table employee information
Table HR data
Form ee information

In the form, I have a few fields that hinge based on email address in HRMS table (I.e - name. Doh. Title, etc..). I had a dlookup, but this does not actually update the related employee information table. Any advice? Is dlookup ok to use?

If I change the fields to text and control source to the field in the employee information table, the data updates correctly.. however I'd like these fields to update automatically from a lookup or reference field stored in the hr date table.

Thanks!

 

[Joe4]

Duplicate: https://www.mrexcel.com/forum/microsoft-access/997814-dlookup-error.html

Since this is just a continuation of that question, let's keep it in one thread. All clarifications, directly related follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #12 here: Forum Rules).