Access crashes with checkboxes

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

Alick [MSFT]

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

david

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Form crashes when I make combo box a bound control 5
change textbox to checkbox 5
Access crashing on a form 1
Group checkboxes on subform 5
Access Form - Lock Fields from Editing 0
Make invisible with a checkbox 3
Access Combobox in Access Visible based on Checkbox 0
Erratic operation with find-record combo. 3

Top