Oracle Forms

Hi ....

I am faciing a really strange situation with checkboxes...I have a table that has 50 columns basically I am displaying 10 columns each on 5 TABS tab A, B, C, D and E. I have checkboxes on 2 tabs. TAB A and TAB D.

The issue is that for my all my checkboxes I have a CHECKED VALUE of 'Y' and UNCHECKED VALUE OF 'N' and other values as 'Not Allowed'. Initial Value is also set to 'N' ie. unchecked. Here is the issue.

I am dynamically disabling all my checkboxes and based on certain other fields I enable / disable it. This works fine. When I come in the form in insert mode all my checkboxes work fine. But when I am on tab A for instance and I save the record and then navigate to TAB D where my other checkboxes are I am not able to select my checkboxes even though they are enabled. It seems it was erroring out so I put a ON-ERROR message and sure enough only if I hit the save button in TAB A and navigate to TAB D and try to hit the check box, I get a ON-ERROR message saying "NORMAL SUCCESSFUL COMPLETION --000" I am not sure what's going on. The value saved in the database is 'N' for all my records so I am not sure why it's not letting me update ...it.

I have no problems if I don't save in TAB A and navigate to TAB D the checkboxes all work fine. Can anyone help shed light on this ? Also, my checkboxes on TAB A works fine even if I save and update the checkbox no errors....

Thanks