View Single Post
  #7  
Old April 20th, 2010, 03:22 PM posted to microsoft.public.access.forms
Al Campagna[_2_]
external usenet poster
 
Posts: 1,462
Default Cascading combo boxes - are they able to do this?

John,
That was just aircode...
It was just an interpretation/representation of the logic.
Please... I would never actually code it like that...
Al

"John W. Vinson" wrote in message
...
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]