Solved

If Is Not Null syntax

Posted on 2008-11-02
2
1,180 Views
Last Modified: 2013-11-27
Experts, would like to have this afterupdate event work but have a syntax.  I have looked around on EE and did not find a solution so I decided to ask a question.  It is my code so there might be a better way to code it.  Basically, on AfterUpdate and if the field txtDateApprovedOrDeclined is not null (meaning that  adate was entered) I would like the other two fields to say Inactive and 100.  thank you

Private Sub txtDateApprovedOrDeclined_AfterUpdate()

    If (IsNotNull(Me.ApprovedorDeclinedcbo)) Then
        Me.Status = "Inactive"
        Me.PrcntComplete = "100"
       
    End If
   
0
Comment
Question by:Petrobras
2 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 500 total points
ID: 22862214
Private Sub txtDateApprovedOrDeclined_AfterUpdate()

    If Not IsNull(Me.ApprovedorDeclinedcbo) Then
        Me.Status = "Inactive"
        Me.PrcntComplete = "100"
       
    End If
0
 
LVL 18

Expert Comment

by:jmoss111
ID: 22862218
Hello Petrobras,

Private Sub txtDateApprovedOrDeclined_AfterUpdate()

    If Not(IsNull(Me.ApprovedorDeclinedcbo)) Then
        Me.Status = "Inactive"
        Me.PrcntComplete = "100"
       
    End If

Regards,

Jim
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

827 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question