So, I am running into another issue. I rarely use Access, so your help is hugely appreciated.
In the form, i enter an email address which populates several fields, one being the employee ID which is a primary field. When I try to move forward in the form, I get an error message that no primary key is found or null. something to that effect. When I take out the Dlookup function and change control source to Employee ID, the table updates correctly and I can move forward. Any ideas?? I am hoping this is just a quick fix.. It was working fine before with dlookup, but i must have done something. Many thanks!