MrExcel Message Board
Survive a PC disaster with Carbonite Online Backup


Go Back   MrExcel Message Board > Question Forums > Microsoft Access

Microsoft Access Questions about Access.

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
Old Nov 7th, 2009, 02:03 PM   #6
jackd
 
Join Date: Oct 2006
Location: Ottawa, Canada
Posts: 379
Default Re: Message Box on Form if Text Box is left Empty

Quote:
Originally Posted by davin2929 View Post
Here is what I have to test for Text Box and Combo box to both have values populated in them. It's not working. Any ideas why? (Items selected I received an error so I removed).

If IsNull(Me.txtOrg) Then
varResponse = MsgBox("Please populate Org ID Field, If you wish to continue without populating the field hit OK otherwise hit Cancel and populate the ORG ID field", vbOKCancel)
If varResponse = vbCancel Then
Me.txtOrg.SetFocus


Else


If (Me.Combo574 = 0) Then
typeResponse = MsgBox("Please populate Audit Type", vbOKOnly)


Else

DoCmd.GoToRecord , , acNewRec
End If

End If
Try
If IsNull(Me.Combo574.value) Then
jackd is offline   Reply With Quote
 

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On

Forum Jump


All times are GMT +1. The time now is 10:09 AM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
All contents Copyright 1998-2009 by MrExcel Consulting.