Prev: Conditional Formatting question
Next: cancel form unload
From: Jeffrey Marks on 1 May 2010 07:36
I've got a subform that I use to create a waiting list for an event.
If a name is selected, currently the user has to click a checkbox to
indicate the waiting list. How do I automatically check the check box,
if a name is selected from the dropdown?
From: Al Campagna on 1 May 2010 08:16
Jeffrey,
What you've described is not "normalized."

If Not IsNull some combo value = some checkbox = True then there's
no need for the checkbox.
For example...
If Not IsNull([cboName]) Then...
is logically equivalent to
If [chkWaitList] = True Then...
--
hth
Al Campagna
Microsoft Access MVP 2007-2009
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."



"Jeffrey Marks" <jeffrmarks(a)gmail.com> wrote in message
news:5199fd63-37e8-430e-95ad-adb7c6421ed9(a)k19g2000yqm.googlegroups.com...
> I've got a subform that I use to create a waiting list for an event.
> If a name is selected, currently the user has to click a checkbox to
> indicate the waiting list. How do I automatically check the check box,
> if a name is selected from the dropdown?


 | 
Pages: 1
Prev: Conditional Formatting question
Next: cancel form unload