Hollis,Virginia
HollisVJ at pgdp.usec.com
Wed Oct 22 16:26:26 CDT 2003
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