Access crashes with checkboxes

  • Thread starter Thread starter Medvjed
  • Start date Start date
M

Medvjed

This is in a adp project. The crash is easy to reproduce.
* Create a form with several databound controls (eg with the wizard, single
form, columnar layout)
one of the controls should be a checkbox bound to a bit field in SQL server.

* Now add a combo box and configure it with the wizard to find a record
based on the value you select in the combo. (eg. search on company name)

* use the form, find a record with the combo, when found try to click the
checkbox.
* access crashes

Is this a known bug, is there a workaround?
If noticed that when you first edit a other field, the crash doesn't happen

Goran.
 
Hi,

It seems a problem; it can be produced with Access 2002 SP2; the workaround
is to change the following line of code from (in combo box afterupdate
event)

Set rs = Me.Recordset.Clone

To:
Set rs = Me.RecordsetClone


Please feel free to reply to the threads if you have any concerns or
questions.


Sincerely,

Alick Ye, MCSD
Product Support Services
Microsoft Corporation
Get Secure! - <www.microsoft.com/security>

This posting is provided "AS IS" with no warranties, and confers no rights.


--------------------
| From: "Medvjed" <[email protected]>
| X-Tomcat-NG: microsoft.public.access.forms
|
| This is in a adp project. The crash is easy to reproduce.
| * Create a form with several databound controls (eg with the wizard,
single
| form, columnar layout)
| one of the controls should be a checkbox bound to a bit field in SQL
server.
|
| * Now add a combo box and configure it with the wizard to find a record
| based on the value you select in the combo. (eg. search on company name)
|
| * use the form, find a record with the combo, when found try to click the
| checkbox.
| * access crashes
|
| Is this a known bug, is there a workaround?
| If noticed that when you first edit a other field, the crash doesn't
happen
|
| Goran.
|
|
|
 
I spoke too soon - the workaround doesn't work for me because
Recordsetclone is read-only, and I need a read-write clone (so I can
save the changes to the checkboxes). Is there a solution for this?

thanks
david
 
Back
Top