Before_Update Cancel=true but can move focus to ribbon

[hecktor888]

I use Forms Before_update event, and set Cancel=true to avoid blank fields. this works fine as long I stay within my form. When I use the mouse to press an icon on my ribbon commandbar I still can open other forms and move the focus to that form.
What can I do that my Form doesn't loose the focus?

[hvsummer]

== if you want to avoid blank field recorded to your table, just use if me.dirty then me.dirty = false

or you don't want to use that code, then set the onfocus event and onlostfocus event, don't set code only in afterupdate.
hope it will help you.

[jforbes]

You could try setting the Form's Modal Property to True. Things can get weird doing this, but it might be what your after. Another option is to open the form like this:

DoCmd.OpenForm "ADialogForm", , , , , acDialog
'or
DoCmd.OpenForm "ADialogForm", WindowMode:=acDialog

Microsoft's Documentation: https://msdn.microsoft.com/en-us/lib.../ff820845.aspx
Which will open the Form up and keep the Focus on it until it is closed.