Solved

Trying to make message appear if combobox value deleted

Posted on 2013-06-18
3
179 Views
Last Modified: 2013-06-18
Here's my afterupdate code.  It isn't working.  No messagebox appears.

If IsNull(Me.cboSelectBudget) Then
    MsgBox "You have deleted an associated budget.  Be sure to enter a construction budget figure."
End If
0
Comment
Question by:SteveL13
  • 2
3 Comments
 
LVL 77

Accepted Solution

by:
peter57r earned 500 total points
ID: 39256949
Try...
If nz(Me.cboSelectBudget,"")="" Then
0
 
LVL 77

Expert Comment

by:peter57r
ID: 39256955
I should have said... what is the datatype of the field bound to your combobox?
0
 

Author Comment

by:SteveL13
ID: 39256961
Number
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say 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

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
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, when working with VBA, learn some techniques for writing readable and easily maintained code.

685 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