Disable Enter Don't go to a New Re.when last field in a Form is fi

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a Form and I have a Subform where the Form has information like
Date,Style,WhoMakethe Operation,QtyNeeded,Comments

when I fill Comments field and press enter the form goes to a new record but
I need to block this option since I need first make an Operation using
subform datas, and when I want to go to anew record I will press a Command
Bottom that I created.


could you help me please in how to disable Enter.


Thanks
 
In the OnExit event of he last field in the Field TabOrder you can set the
focus back to the first field in the TabOrder, so it will create a loop
instead of adding a new field.
 
Hi Ofer, thank you so much for your help, I had a code in AfterUpdate like
this, but one time it do works, but after that it does not work,

but now your answer helped me.

maybe you remember me, I'm from Mexico.


Thank
LD
 
Sure I do, and if I'm not wrong it's Lorenzo. (I hope I spelled your name
correctly), it's been a while since the last post, I hope you are OK.

The after update event will work only if you update the field, so if you
didn't change the value in it, it wont run the code in that event.
And this is why it better to put the code on the OnExit event.
 
Yes I'm Lorenzo and I;m OK, I hope you are OK too.

Thank you so much for your help, now my Program is running correctly.

Thanks
God Bless you.
 
Back
Top