Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Error Trapping on a subform

Status
Not open for further replies.

Leventcos21

Technical User
Oct 7, 2004
77
US
I am stuck on the syntax of error trapping a subform. Basically, I have form with a subform and if this subform and on the main form I have a check box that will lock all the records and check to see ISNULL on both forms. The main form is working fine.

How do I syntax the subform
Thank you

Private Sub LockEdit_Click()
If.................
LockEdit.Value = False
ElseIf IsNull([Forms]![sfrmProcessOwner]![cboProcessOwner]) Then
MsgBox "Process Owner Field is empty, Please Select"
LockEdit.Value = False
Else
...................
End If
End If
 
never mind I figured right after I posted it :)

ElseIf IsNull([sfrmProcessOwner].Form![cboProcessOwner]) Then

....
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top