View Single Post
  #4 (permalink)  
Old January 12th, 2005, 08:51 PM
Bob Bedell Bob Bedell is offline
Friend of Wrox
 
Join Date: Jun 2003
Location: , , USA.
Posts: 1,093
Thanks: 1
Thanked 12 Times in 11 Posts
Default

Or for a simpler approach you could go with this sort of thing:

Private Sub cmdSave_Click()
    If IsNull(Me.[GAppropriation]) Or _
        Len(Me.([GAppropriation]) = 0 Then
        MsgBox "[GAppropriation]Must be Filled In Before Proceeding"
        [GAppropriation].SetFocus
        Exit Sub
    End if

    DoCmd.GoToRecord , , acNewRec

End Sub

HTH,

Bob