I need help with getting fields to auto fill in after i put in related info.

[smroussel]

I have a form based on a table that is related to another teacher info table by a social security number field. When they type a social into the form i want the teachers name associated to that social in the teacher info table to pop into the appropriate box.

 

[Pat Hartman]

Take a look at this example:

http://www.access-programmers.co.uk/forums/showthread.php?p=293920#post293920

 

[smroussel]

I tried the dlookup() function. Please try and see where i've gone wrong.