I have a form, frmperminfo, which has various demographic info including name and SSN. On this form is a button to open the Needs Assessment form. What I want to do is have Access look out and see if the SSN on frmperminfo has a corresponding record in the Needs Assessment table. If it does, then open the needs assessment form with that person’s SSN. If there is not a record for the person yet, then open up a blank form, but automatically put in the first name, last name and SSN from perminfo. I hope this makes sense and I tried to fiddle with macros and conditions. The closest I got was with Dlookup, but couldn’t figure out how to get that to come up with true or false value.
Thanks for any help!
Jodi