Disabling a field when in Change mode

[smrogers]

I have a field that I DON'T want changed when in change mode (this form is modal); I'm using the CanArrive event for the field in question, and I'm testing whether the form is in change mode using 'parentform.mode_get()'in the script attached to the event.

If the result is '1' (Change), I have the script disabling the field object and setting focus to another field for data entry. My problem is that if I switch from View to Change via the menu selection 'Records->Change Records', the field I want to disable happily allows the user to access it and change it - i.e., the test isn't working.

I don't know if I'm using the wrong event, or if the form isn't refreshing properly, or something else is amiss.

Just before I test the mode, I have a line that does a 'parentform.refresh_layout()'. This doesn't seem to help; a variable on the form (for debugging purposes) shows the current mode, and when I go into Change, it still says View.

If someone can enlighten me, that would be great...

[Keith Hubert]

Re: Disabling a field when in Change mode

Hi Shawn,

Use the Enabled-> dynamic option in field properties.

[Tbaker]

Re: Disabling a field when in Change mode

Try using the onArrive event for the fields that are to be disabled if the form is in change mode

In the onArrive event you would use

 if parentform.mode_get()="Change" then 
                 parentform:anotherfield.activate()
end if

Of course you would substitute you field name for anotherfield.

If you wanted to update the variable that shows what mode the form is in

You could set the forms timer to 1 and then in the forms onTimer event you would have

var->yourvariablename=parentform.mode_get()

It would refresh the form with the mode every second.

FWIW

Tom

Edit. Finally got to a computer that had v10 and after reviewing the code made changes - removed the ".value" after yourvariablename and then removed the parentform.refresh_layout() from the ontimer event - both were not necessary.

[jkletrovets]

Re: Disabling a field when in Change mode

I would take a slightly different approach on this. If the form is modal....I would place the code on whatever "Edit Button" methodology you have. So...the first line of code on a button would be to put the form into change mode and then put the code to disable whatever fields you want disabled. I would do it this way so the code is implemented at the start of the data entry / editing process so it does not have to be evaluated on a field by field basis.

Regards,

Jeff

[jkletrovets]

Re: Disabling a field when in Change mode

I made a quick demo. Open the "People_frm" and hit the edit button. The SSN and Gender fields are disabled and their fill color is changed so the user knows they are not editable.

[smrogers]

Re: Disabling a field when in Change mode

Thanks much to all that put in the time to answer my question; We're wrapping up tax season today so I won't have a chance to play with this right now - when I do, I'll report back on my (hopefully) success.

[Jerry Hartness]

Re: Disabling a field when in Change mode

Jeff

I have been trying to do this thru the disable.object, which does disable the object, but I want to disable an object under a certain condition. In the checkbook I have put together I have a field called "Cleared" (logical) and when the check has reconciled with the bank I check "Cleared". In your example I want to disable the check number and the amount (or deposit) if the "Cleared" is checked for "true", however the other fields would be available for editing. I'm not an expert on Xbasic so could you or anyone take your script and code it with something like "If Cleared = .t. then run you script or cancel your script if Cleared not check. I have been running my church check book now on Quicken for over 10 years and it doesn't give me the reports I really want, but I can do this in A5, and the above would be helpful. Thanks to you or anyone who responds.



Jerry

[MikeC]

Re: Disabling a field when in Change mode

Hi Jerry,
More information, mainly regarding the context of your problem, is needed as each context many times means a different solution....Is the problem on a form, a browse, an xdialog...? a single table, a set (and if so, what is the parent, the children, the linkages, the relationships?)...? If a browse are you saying you want to disable just some rows of the browse?

These are but a few thoughts I had when considering your issue! Maybe Jeff knows more as it seems you directed your question mainly at him, but I certainly will need more than what you have given in order to take a stab at it! :)

[Jerry Hartness]

Re: Disabling a field when in Change mode

Mike, thanks for your consideration,

No, it's just a one file, one form dbf, just wanta' use Jeff's example (which
disables) but I want to put a condition on it by checking the logical field
T or F to disable or enable. I can put the script on his example to enable
but that's when I have my problem, if Cleared = t then (run Jeff's code) to disable, else if cleared = f then (run my code) to enable. As you can see the book for xbasic dummies hasn't made it to my house yet.

thanks

Jerry

[crimmelcp]

Re: Disabling a field when in Change mode

if Cleared = .t. then
run Jeff's code
else
run jerry's code
end if

OR you could have

if Cleared = .t. then
run Jeff's code
end if

if Cleared = .f. then
run jerry's code
end if

[jkletrovets]

Re: Disabling a field when in Change mode

Jerry,

Sorry for the delay.....been swamped on a project. In any case, did you get this sorted?

Regards,

Jeff

[Jerry Hartness]

Re: Disabling a field when in Change mode

Jeff

Yes I did, thanks for your script and Charlie Crimmel's easy fix. Works just fine

thanks

Jerry:)