Al, Karl, John - I really appreciate your input into my question. I now have
a couple of options to trial - I'll post back if any problems. Many thanks
again guys.
--
Joe


"John W. Vinson" wrote:

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