[AccessD] Setting controls to null (AXP)

I thought you couldn't use '= null' ever?! If only I had just tried it...

LOL

Thanks Bob

-----Original Message-----
From: Bob Gajewski [mailto:bob at renaissancesiding.com] 
Sent: 15-Apr-2003 15:34
To: 'accessd at databaseadvisors.com'
Subject: RE: [AccessD] Setting controls to null (AXP)


Roz

In the BeforeUpdate:

==============================
  If EverythingLooksGood = True Then
    ...
  Else
    Cancel = True
    Me.MyComboBox.Value = Null
  End If
==============================

HTH,
Bob Gajewski



On Tuesday, April 15, 2003 10:10 AM, Roz Clarke
[SMTP:roz.clarke at donnslaw.co.uk] wrote:
> Hi again everyone
> 
> I have a combo box containing staff records, bound on ID field. I want 
> to display all the records even though some of them will be invalid 
> choices, and display an error message giving a reason if the user 
> tries to make an invalid selection and offereing to take certain 
> actions, blah blah.
> 
> If the user chooses to cancel rather than proceed, I need to then set 
> the combo box back to null. I can't set it to a 0 or a zero length 
> string, it HAS to be a null. How???
> 
> Hope someone has the key
> 
> Roz
> 
> 
>  << File: ATT00009.htm >>  << File: ATT00010.txt >>

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com