[AccessD] Check for Null on a Subform

Virginia

...try If IsNull(Forms!frm_DDPMain!frm_DDPSub.Form!TypeTask) Then

William Hindman
<http://www.freestateproject.org> - Do you want liberty in your lifetime?


----- Original Message ----- 
From: "Hollis,Virginia" <HollisVJ at pgdp.usec.com>
To: <accessd at databaseadvisors.com>
Sent: Wednesday, October 22, 2003 5:26 PM
Subject: [AccessD] Check for Null on a Subform


> Before a form is closed I need to check for an entry in a certain field
> (TypeTask) on a subform. How do I refer to the subform (frm_DDPSub) from a
> close button on the main form (frm_DDPMain)?
>
> I tried this code on the close button, but get an error - "Object does not
> support this property or method". What am I doing wrong?
>
> Virginia
>
> *****************
>   If IsNull(Forms!frm_DDPMain!frm_DDPSub.TypeTask) Then
>             MsgBox "The type of task must be entered" & vbCrLf,
vbCritical,
> " Entry Required"
>         DoCmd.CancelEvent
>         Forms!frm_DDPMain!frm_DDPSub!TypeTask.SetFocus
>
>     Else
>         DoCmd.RunCommand acCmdSaveRecord
>         DoCmd.Close acForm, Me.Name
>     End If
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>