Solved

If Is Not Null syntax

Posted on 2008-11-02
2
1,179 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 - Access MVP) 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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

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…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

809 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