Prev: Automatically insert date when other field is true?
Next: Check Code Please
From: mls via AccessMonster.com on 29 Jan 2010 12:14
Hi, I want to create an alert to check the Final( checkbox ) field, if
date_issued is enter.
if date_issued is null then do nothing, In what even I have to code this and
how?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/201001/1

From: Marshall Barton on 29 Jan 2010 12:45
mls via AccessMonster.com wrote:

>Hi, I want to create an alert to check the Final( checkbox ) field, if
>date_issued is enter.
>if date_issued is null then do nothing, In what even I have to code this and
>how?


Based on just that one requirement, you can use the date
text box's AfterUpdate event.

If Not IsNull(Me.date_issued) Then
MsgBox "check box message here"
End If

--
Marsh
MVP [MS Access]
 | 
Pages: 1
Prev: Automatically insert date when other field is true?
Next: Check Code Please