[AccessD] Check Box in Unbound Form

Susan,

What is the value of Me at the time you execute one of these statements?
If it is not the form on which chkMyCheckBox resides, then no version of
the assignment statement will work.  Maybe Me is pointing to the
recordset instead of the form.  If it is, don't feel stupid since I and
many others have made this same mistake.

Charles Wortz
Software Development Division
Texas Education Agency
1701 N. Congress Ave
Austin, TX 78701-1494
512-463-9493
CWortz at tea.state.tx.us

P.S.  How is the paperwork coming along to make you and your beloved
legally Geller's?


-----Original Message-----
From: Susan Geller [mailto:sgeller at cce.umn.edu] 
Sent: Monday 2003 Jun 09 10:29
To: accessd at databaseadvisors.com
Subject: [AccessD] Check Box in Unbound Form


Access XP.  I have an unbound form with a checkbox.  In my code, I am
opening a recordset and I want to set the checkbox to true/false
depending on what is returned in my recordset.  What is syntax for
setting a check box to true/false?  Once I know that, I can deal with
what is returned in the recordset.  These don't work:

Me!chkMyCheckBox = True
Me!chkMyCheckBox.format = True

TIA.
--Susan

Susan B. Geller
Office of Information Systems
College of Continuing Education
University of Minnesota
306 Wesbrook Hall
77 Pleasant Street SE
Minneapolis, MN 55455
Phone:  612-626-4785
Fax:  612-625-2568