FORM/SUB FORM SOLUTION

[John]

Thanks everyone for all your help. I came up with a different solution that I would like to share with everyone

Here is the syntex I used. Actually works beautifully and its extremely simples

Private Sub Form_AfterUpdate(
subfrm_ProspectInformation.Form!PrspInfoHSAttend = IsNotNul
subfrm_ProspectInformation.Form!PrspInfoHSAttend = 666666

End Sub

 

[Albert D. Kallal]

Thanks everyone for all your help. I came up with a different solution

that I would like to share with everyone.

Here is the syntex I used. Actually works beautifully and its extremely simples.

Private Sub Form_AfterUpdate()
subfrm_ProspectInformation.Form!PrspInfoHSAttend = IsNotNull
subfrm_ProspectInformation.Form!PrspInfoHSAttend = 6666666

End Sub

As noted, the first line of the code is incorrect....you only need