validate detail field on subform

M

mcnewsxp

i am using a continuous form as a subform for related detail records. i
need to be able to make sure a certain field on the detail form in not blank
when a save button is clicked on the main form. i can't find a handle to
this field.
thanks,
mcnewsxp
 
M

mcnewsxp

this works:

If IsNull(Forms!frmNewSeq!frmNewSeqSub.Form.Request) Then
MsgBox "Request can not be blank", vbExclamation
Forms!frmNewSeq!frmNewSeqSub.SetFocus
Exit Sub
End If
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple subforms 0
coding between subforms 5
Show Record on subform based on current subform Line ID 1
Spell Check specific fields on a subform 2
Locate record in a subform 1
Many to Many junction table and subforms 1
filtering main form via selecting record in subform 5
Copy text to subform 2

Top