UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Iif(IsNull on button click    
 
   
Rodders
post Aug 2 2006, 02:52 AM
Post #1

UtterAccess Addict
Posts: 100
From: UK, Belfast
Hi

I have a form that has a drop down.

If the user doesn't select an item from the drop down (ie it is null) the I want the code on the close button to change the value of the field to zero.

I am stumped.......

tried
Me([Visit_rds_id]) = IIf(IsNull(Me([Visit_rds_id])), "0", [Visit_rds_id])

But it didn't work!

Rodders
Go to the top of the page
 
+
Larry Larsen
post Aug 2 2006, 03:04 AM
Post #2

UA Editor + Utterly Certified
Posts: 22,722
From: Melton Mowbray,Leicestershire (U.K)
Hi
Why not set the default value to '0'..?
(IMG:http://www.utteraccess.com/forum/style_emoticons/default/thumbup.gif)
Go to the top of the page
 
+
Rodders
post Aug 2 2006, 03:24 AM
Post #3

UtterAccess Addict
Posts: 100
From: UK, Belfast
Doh!

Cheers, wood and trees, I have been tweaking this for soooo long.

Stronger coffee needed....

Thank again,

Rodders
Go to the top of the page
 
+
Larry Larsen
post Aug 2 2006, 03:27 AM
Post #4

UA Editor + Utterly Certified
Posts: 22,722
From: Melton Mowbray,Leicestershire (U.K)
Hi Rodders..
I always put in a litle drop of "Paddys" whisky when I need a stronger coffee intake.
Glad I could help..
(IMG:http://www.utteraccess.com/forum/style_emoticons/default/thumbup.gif)
Go to the top of the page
 
+
« Next Oldest · Access Forms · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 20th May 2013 - 11:14 AM