[AccessD] Setting controls to null (AXP)

Bob Gajewski bob at renaissancesiding.com
Tue Apr 15 09:33:47 CDT 2003


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 >> 



More information about the AccessD mailing list