Hi Everyone,

I designed couple of forms, one for applicant and one for Stats on that Applicant. Problem is Stats Form contains some fields which are same as on Applicant Details form. If user changes the details on Applicant Form they need to be changed on the Stats form. If it's a New Applicant it should open the form and add the details to Stats.

I can't do a check so when it opens the Stats form it can check whether or not that Applicant exist. I used find record and if it finds a match it performs update if not it should goto new record. The check doesn't seems to work

I have used if-else-than but if could not find a record it goes to first record instead of going to New Record.

If someone can help on this matter I'll be gratefull. many thanks in advance.

Be certain the subform's Master Link and Child Link properties are properly set. On Update event of the main form, store the appropriate values of the main form into the subform.