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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

If... Then..... Problem

Status
Not open for further replies.

pbrown2

Technical User
Jun 23, 2003
322
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top