Checkboxes in form causing crashes

  • Thread starter Thread starter markd
  • Start date Start date
M

markd

Got a system with an Access2000 ADP f.e. to a SQL2000
Enterprise b.e. One of the primary work forms includes
numerous survey subforms with checkboxes. Those subforms
were fed using "Set Forms!yadayada!sbfrm.Recordset = rs"
statements, and it's run fine for a year.

We're in the process of converting the f.e. to an AccessXP
ADP file with the same SQL2000 b.e. Any attempted update
of a checkbox in the subforms causes an immediate system
crash. All text box controls, combo boxes, radio buttons,
etc. work fine in the same subforms.

The subform recordsets were tapping a single table only
(no joins), set for optimistic locking, etc.

Changing the subforms to use a Recordsource sql statement
rather than using a Recordset solved the problem, but that
didn't seem like a great solution. Anybody seen this
before?
 
I'm not sure if Microsoft ever published an article about it but the problem
is a known bug that was fixed in Access 2003. If you're stuck with using
Access 2002 and you don't want to use a direct SQL statement, then the only
other options are to use a different control besides the checkbox or to
leave the checkbox control unbound and set its value programmatically.

Brian M. Sockey
www.televantagenorthwest.com
 
It's a corporate client migrating Office and O/S for
several thousand stations, so 2003 won't be an option for
a small team. Good to know for the future though. Many
thanks for the assistance.
 
Back
Top