Form Dlookup

[jbtyler]

Form Issue:
PD Course Enrollment:



I would like the First and Last Name Text fields to perform a DLookup against the JagNumber immediately to the right. The JagNumber field is related to the Faculty_Info table which has this information. I can't seem to get the syntax right. I would like this to ensure that when people are entering PD they are entering it for the right person. Also this is my first ACCESS project in 15 years and I was not that good at it back then Basically the DB is design to track Faculty Members that interact with our dept for Professional Development Training. The university works mostly off of the Jag Number system so I tried to incorporate it as much as possible. If anyone has any improvements or code to make things easier please share it with me. Lastly, I have not built the navigation structure yet but it will be one of the last things I do once I know everything works. I have attached the DB for your review.

I will be adding a "credits" section to it to properly acknowledge all help.

Thanks for your help.

[pbaldy]

Can't open the sample, but this would be more efficient if you're using a combo:

http://www.baldyweb.com/Autofill.htm