MS Access Form OnKeyDown Event with Text Boxes Not Working Properly

Hello,

So I have a form that filters records in the top section based what information is filled into  combo and text boxes.

I have added an OnKeyDown event to each of these combo and text boxes and when I press the Enter key after putting in one of the values into the combo boxes, it works perfectly. However, when I press the Enter key after puttin in one of the values into the text boxes, it tabs over to the next box and then I would have to press Enter a 2nd time for it to begin the query.

I am kind of figuring out VBA a little through working with it in this form. Can you please let me know what I would have to do for it to work properly (that is, press Enter key on any of the boxes in top section and have it filter the results in the subform)??
Form-Building-Using-FiltersRev-4.accdb
IEHP1Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
IEHP1Connect With a Mentor Author Commented:
I believe I have figured it out.....

If I change the Forms command button DEFAULT property to YES, it will work, but let me test this first.......
0
 
IEHP1Author Commented:
YEP, I answered my own question. Sorry about the post, I guess more Knowledge to the Knowledge Base.....
0
 
IEHP1Author Commented:
Set DEFAULT Property o YES in order for your Command button to Activate when press Enter key in a text box.
0
All Courses

From novice to tech pro — start learning today.