I am trying to use dlookup to pull SSN's from a different table based on the last name. This is on a splitform. I have included the expression I am trying to use. I have been wrestling with this for a week or so and stumbled accrss this site. Can anyone help me?
=DLookUp("[SSN]","tblPesonalInfo","[Last Name]=Form![Last Name]")
=DLookUp("[SSN]","tblPesonalInfo","[Last Name]=Form![Last Name]")