When press tab, ignore keypress event

[jlgray0127]

In forms, I have an event set at the keypress event, that opens a subform for the user to type into another form, if they are trying to enter data. (I have one record, that could over a period of time, need many notes added to it. I capture all this data in another table to keep all the notes separate for this one record)


If the user is using the tab key, and does not want to type a comment, I'd like for Tab to not trigger the keypress event.
I can not find a good sample of code that works.

Simply put, I want any key but tab to trigger the keypress event. Can someone help me create a code that basically ignores the keypress event if tab is the key that is pressed?

Thank you!

[RuralGuy]

Why not just change it to a null (0) in the KeyPress event.

[jlgray0127]

I'm not sure what you mean there? I've not done much with the keypress event, other than using it to trigger an action... never with any criteria.

[RuralGuy]

Okay, I'll give you some links that should help. We should probably use the KeyDown event instead of KeyPress.
https://msdn.microsoft.com/en-us/lib.../ff194937.aspx
http://stackoverflow.com/questions/2...unction-in-vba
https://msdn.microsoft.com/en-us/lib...(v=vs.60).aspx

[RuralGuy]

Did you figure it out yet? I'm willing to assist further if you would like.