Closing a Form

[Kerry Bugger]

I have a form with an embeded brower in it. When I close the form it all ways saves the last record. I would like to be able to close it without saving, is there a way.

Thanks,

[MikeC]

Re: Closing a Form

Kerry,
This is one of the automatic things that Alpha does (just like when navigating from row to row in a browse will save a record)....almost all times this is wanted I believe--you could add script to either the CanSave in the form or the OnRecordSave in field rules or add a cancel button that cancels pending changes in various ways......need to know more about it really to give a more specific response.

[Mendy]

Re: Closing a Form

If you have a close button you can in design mode doubleclick and edit the close form/browse event. Click on edit and there is a check box If user has not saved the current record, save record before closing form. You could try this and see if it does what you want. If it does you could possible have two close buttons, one for save and one for don't save to cover both scenarios. Don't know reason for don't save, but I too have things that go contrary to accepted practices.

[Mendy]

Re: Closing a Form

Retract doubleclick, was in V10.5. In V9 it would be right click to access. Sorry for my error.

[Kerry Bugger]

Re: Closing a Form

Maybe just a little more information. what it does is if I have a blank record on the form and close it save the blank to the file. I would like it to ask if I would like to save so I can say no and it won't be saved, so I don't have blanks in the file.

[MikeC]

Re: Closing a Form

Kerry,
Here is where the overwhelming part of Alpha comes in....there are several ways to prevent what you are having issues with and is as dependent on context as it is on how you personally want to do it!

You could restrict entry for the form/browse and then if indeed you want to save a record, unrestrict...save...re-restrict. This can also be done utilizing the "read only" property instead.

You could place code on the CanSave of the form/browse to say cancel a save if a certain field(s) are blank/incorrect.

You could use field rules---the CanSaveRecord event perhaps.

You could also make the user go to specific fields/etc and not let them out of it until they fill in the necessary data except maybe to use a Cancel button.

You could also just have an operation performed whenever that will delete any records that are not filled in as you want....

These are just the ones that occur to me now.....

Choose one that you prefer....try it and if problems let us know!

:)

[CALocklin]

Re: Closing a Form

You could use field rules---the CanSaveRecord event perhaps.

That would be my preference. That way it isn't necessary to worry about adding/editing the code in every form. Something like this - assuming the criteria is that you do not want to save the record unless either the first name, last name, or company name exists:

tc = table.current()
IF tc.First_namf + tc.last_namef + tc.Comp_namef = ""
    'All are blank - don't save the record.
    cancel()
END IF

The only real issue is determining what criteria you want to use to determine whether or not to save the record.