View Single Post
  #5  
Old April 20th, 2010, 06:04 AM posted to microsoft.public.access.forms
John W. Vinson
external usenet poster
 
Posts: 18,261
Default Cascading combo boxes - are they able to do this?

On Mon, 19 Apr 2010 23:10:15 -0400, "Al Campagna"
wrote:

Karl,
I had in mind two colums in cbo1...
Injury SubInjury

AfterUpdate... is cbo1.Column(1) = Null then...

OnCurrent... is cbo1.Column(1) = Null then...


One correction: Nothing - not even another NULL - is ever equal to NULL. These
comparisons will fail regardless of what's in Column(1). The correct syntax is

If IsNull(cbo1.Column(1)) Then...

--

John W. Vinson [MVP]