Solved

MS Access Form OnKeyDown Event with Text Boxes Not Working Properly

Posted on 2013-01-31
3
570 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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

832 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