Y
Yarik Mezheritsky via AccessMonster.com
Hello everyone!
The setting:
-- It is an Access 2000 ADP application with SQL Server database.
-- There is a continuous form.
-- The underlying recordset has a field of type "bit" (as well as other
fields).
-- The underlying recordset is updateable.
-- The form has a chekbox bound to the abovementioned bit field (as well as
other controls bound to other fields of the underlying recordset).
The problem:
Whenever a user clicks the checkbox, the current record gets "stuck": any
attempt to move focus to another record (for example, by clicking on
controls of other records, or by using keyboard) silently fails. There are
no any error messages. It just becomes impossible to select (let alone edit)
any other record until the entire form is required.
Notes:
Interestingly, when a user tries to select another record, the record whose
checkbox has been clicked does get updated...
Also interestingly, sometimes the problem does not occur if, before
clicking the checkbox, user does some other change to the record. For
example, it does not occur when a user first changes some other field by
selecting a value from the bound combobox.
Unfortunately, I cannot reproduce this problem at will on a simplistic form
(e.g. on a form that has single-table recordset having just a couple of
fields). So it looks like it is some aspect of the more complex production
form that triggers the problem. Does anybody know what could become such a
trigger?
Or is it one of the notorious Access bugs that gets triggered almost
randomly?
Any comments would be greatly appreciated!
Thank you,
Yarik.
The setting:
-- It is an Access 2000 ADP application with SQL Server database.
-- There is a continuous form.
-- The underlying recordset has a field of type "bit" (as well as other
fields).
-- The underlying recordset is updateable.
-- The form has a chekbox bound to the abovementioned bit field (as well as
other controls bound to other fields of the underlying recordset).
The problem:
Whenever a user clicks the checkbox, the current record gets "stuck": any
attempt to move focus to another record (for example, by clicking on
controls of other records, or by using keyboard) silently fails. There are
no any error messages. It just becomes impossible to select (let alone edit)
any other record until the entire form is required.
Notes:
Interestingly, when a user tries to select another record, the record whose
checkbox has been clicked does get updated...
Also interestingly, sometimes the problem does not occur if, before
clicking the checkbox, user does some other change to the record. For
example, it does not occur when a user first changes some other field by
selecting a value from the bound combobox.
Unfortunately, I cannot reproduce this problem at will on a simplistic form
(e.g. on a form that has single-table recordset having just a couple of
fields). So it looks like it is some aspect of the more complex production
form that triggers the problem. Does anybody know what could become such a
trigger?
Or is it one of the notorious Access bugs that gets triggered almost
randomly?
Any comments would be greatly appreciated!
Thank you,
Yarik.