ADP Crashes - Form RS In-Line Function

Using Access 2002 access project. I have a subform that's record source is a
paramarized function. When going to a record, if the first field you try
changing is a checkbox - then Access crashes. (access encounted an error and
needs to close....)
I have tried the same thing on a diffrent computer (access 2002) running off
a diffrent sql server - and same error.
Any clues???? When I try in Access 2003 all is fine however the machines
running the app are all 2002.

Not only Access 2002 may crashes but it can place the value for the checkbox
into another field.

Two choices: remove SP2 for WinXP or upgrade to Access 2003.

S. L.

"Abe Munk" Abe wrote in message
...
Using Access 2002 access project. I have a subform that's record source is
a
paramarized function. When going to a record, if the first field you try
changing is a checkbox - then Access crashes. (access encounted an error
and
needs to close....)
I have tried the same thing on a diffrent computer (access 2002) running
off
a diffrent sql server - and same error.
Any clues???? When I try in Access 2003 all is fine however the machines
running the app are all 2002.

Third choice: unbound the checkbox and update the values yourself with VBA
code on entering and leaving the form. (However, personally, I wouldn't do
this because Access 2002 has other bugs that can it you as well.)

S. L.

"Sylvain Lafontaine" sylvain aei ca (fill the blanks, no spam please)
wrote in message ...
Not only Access 2002 may crashes but it can place the value for the
checkbox into another field.

Two choices: remove SP2 for WinXP or upgrade to Access 2003.

S. L.

"Abe Munk" Abe wrote in message
...
Using Access 2002 access project. I have a subform that's record source
is a
paramarized function. When going to a record, if the first field you try
changing is a checkbox - then Access crashes. (access encounted an error
and
needs to close....)
I have tried the same thing on a diffrent computer (access 2002) running
off
a diffrent sql server - and same error.
Any clues???? When I try in Access 2003 all is fine however the machines
running the app are all 2002.