Solved

MS Access Form OnKeyDown Event with Text Boxes Not Working Properly

Posted on 2013-01-31
3
562 Views
Last Modified: 2013-01-31
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
0
Comment
Question by:IEHP1
  • 3
3 Comments
 

Accepted Solution

by:
IEHP1 earned 0 total points
ID: 38841508
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
 

Author Comment

by:IEHP1
ID: 38841522
YEP, I answered my own question. Sorry about the post, I guess more Knowledge to the Knowledge Base.....
0
 

Author Closing Comment

by:IEHP1
ID: 38841528
Set DEFAULT Property o YES in order for your Command button to Activate when press Enter key in a text box.
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question