Sub Form on Continous form

[iamtrying]

I am having a hard time with a subform updating the SSN field from the main form which is a continous form. The main form has information about all employees. The subform house all of the required examinations of all employees. The two tables are DBO_employee and Exam_Histry. The relation ship is SSN, although the forms are link on LastName, Firstname, and SSN. I would like have the SSN field on the subform populate with the employee's SSN when a new record is created from the main form, or when a new exam is added to the subform. The LastName and FirstName does populate in the Exam_Histry table.

 

[TheAceMan1]

How are ya iamtrying . . .

Is this a true subform or an idependently opened form?

See Ya! . . . . . .

Be sure to see FAQ219-2884:

 

[iamtrying]

Hey Ace iamtrying, How are you doing?

This is a subform created from a query from a separate table and linked to main form.

 

[iamtrying]

Is there anyone with a solution??

 

[TheAceMan1]

iamtrying . . .

Sorry to get back so late. Church duties took up the whole day & night yesterday. Anyway:

[blue]The relation ship is SSN, although the forms are link on LastName, Firstname, and SSN.[/blue]

[blue]SSN[/blue] is surely your [blue]unique identifier[/blue] as its possible to have duplicate first & last names but not SSN. Link on the [blue]SSN[/blue] only! This should resovle the issue . . .

See Ya! . . . . . .

Be sure to see FAQ219-2884:

 

[iamtrying]

Aceman,

I was left high and dry yesterday, but the solution was simple. I created a subform from the Exam_Histry table and linked it to the main form on SSN. Now, when a new record or exam is created, lastname, firstname, and SSN is pouplated correctly.

Thanks

I just keep trying .......iamtrying