Status Field to "Open" Issues

[billgyrotech]

Hello,


When the database opens there is a command button "Administrator" to click then enter password "admin".


Then on the next form AFRs1 upper right is a Status field. When it is "Open" the fields on the form should be editable but this only allows one change then it locks on one field and cannot do anything else until exiting the form AFRs1.


Does anyone know why this is happening please?


Thank you,
Bill

 

[June7]

I am not getting that behavior. I can change values of any and multiple controls.

Which value are you editing when this happens to you?

 

[billgyrotech]

Progressive inspection area thank you

 

[June7]

Okay, correction. I did not try editing every control, just spot checked and did not hit the problem.

I commented out all the code in Exit event of two textboxes and issue goes away. Why are you using Exit event?

 

[billgyrotech]

I'm not sure if was provided by another member on here

 

[billgyrotech]

Was it the spelling and grammar checker?

 

[billgyrotech]

Can they be moved to different events ?

 

[June7]

At first I just commented the spelling checker command, still had issue. When you exit the control, code just sets focus back to control so you end up in a nasty loop. Not sure different event will resolve that.

I have never used Exit event. I have never invoked the spell checker either.

 

[billgyrotech]

Okay thanks I will do some more research on the spell checker for now this is solved since you found what was wrong.


Cheers!

 

[June7]

I reactivated just the SpellChecker command. The spell checker opened and proceeded to spell check the entire dataset of the form, moving record to record.