Any way to disable shift+enter ?

[dmartinez]

I'm looking for a way to disable the saving of records through shift+enter. When this happens by accident it cause semi-empty records. I tried setting an elaborate IF statement to check for certain fields to be filled in on the forms before update but that isn't firing correctly possibly. If the shift-enter isn't the issue, any ideas what can be the cause of records saving themselves before the record is completed on the form?

thanks, dave

 

[missinglinq]

Has does one "accidentally" hit <Shift> + <Enter> ???

I've spent years "idiot proofing" programs, including a number where <Shift> plus another key was used to perform a function, and I can't ever remember having to address users "accidentally" hitting a 2 key combination.

Just curious. Color me yellow.

The Missinglinq

 

[ghudson]

You have quite a few choices. You can make the fields "required" in the design view of the table. You can use the forms BeforeUpdate event to test if the fields meet your criteria [is not null] and cancel the event if false. You can use the AutoKeys macro to disable that key board combo. You can create a custom routine to verify if everything is complete and or a certain button is clicked before the user can move to another record, save the record, exit the form, close the database, etc. This link will show you how I do the latter... A better mouse trap?

HTH