Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

MS Access Form OnKeyDown Event with Text Boxes Not Working Properly

Posted on 2013-01-31
3
Medium Priority
?
597 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

722 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