Currently:
Access97
Form = Altima
SubForm = Altima Subform (named Altima Data within Form Altima)
Here is the code that I am working on (It is the last (3rd) if statement that is causing problems.)
Private Sub Command36_Click()
'First If is to ensure user has picked a Project Classification
If IsNull(Me![Project Classification]) Then
MsgBox ("Project Classification is Missing, Please Complete"
[Project Classification].SetFocus
Else
'Second If is to ensure user provides some type of description
If IsNull(Me![Notes]) Then
MsgBox ("Project Description is Needed, Please Complete"
[Notes].SetFocus
Else
'Last if is to ensure the user provides comments
If IsNull([Description].[Altima Subform]) Then
MsgBox ("This Item Has No Dollar Amounts, Please Complete"
Else
Text12.SetFocus
Text14.SetFocus
DoCmd.GoToRecord , , acNewRec
[Project Classification].SetFocus
End If
End If
End If
End Sub
From the last statement:
[Description] is a field from the subform which needs to be filled in before the user can move on to the next step.
However as it is currently set up, the error says it can not find the field description.
Thank you for any and all help,
PBrown
Access97
Form = Altima
SubForm = Altima Subform (named Altima Data within Form Altima)
Here is the code that I am working on (It is the last (3rd) if statement that is causing problems.)
Private Sub Command36_Click()
'First If is to ensure user has picked a Project Classification
If IsNull(Me![Project Classification]) Then
MsgBox ("Project Classification is Missing, Please Complete"
[Project Classification].SetFocus
Else
'Second If is to ensure user provides some type of description
If IsNull(Me![Notes]) Then
MsgBox ("Project Description is Needed, Please Complete"
[Notes].SetFocus
Else
'Last if is to ensure the user provides comments
If IsNull([Description].[Altima Subform]) Then
MsgBox ("This Item Has No Dollar Amounts, Please Complete"
Else
Text12.SetFocus
Text14.SetFocus
DoCmd.GoToRecord , , acNewRec
[Project Classification].SetFocus
End If
End If
End If
End Sub
From the last statement:
[Description] is a field from the subform which needs to be filled in before the user can move on to the next step.
However as it is currently set up, the error says it can not find the field description.
Thank you for any and all help,
PBrown