Enter Key Behavior - Use a form to enter report criteria

Enter Key Behavior - Use a form to enter report criteria

Post by S2FyZW » Fri, 07 Oct 2005 05:29:06


I created a form using the instructions in MS Access help titled "Use a form
to enter report criteria". After entering the Beginning Date in the text box
and pressing the Enter key the form closes and runs the report. The report
in turn errors due to no criteria being entered. I have checked
Tools-Options-Keyboard and it is set to "Move After Enter: Next Field".
However, after pressing Enter, it is not moving to the next text box to enter
the End Date. Any ideas on what I am doing incorrectly?
 
 
 

Enter Key Behavior - Use a form to enter report criteria

Post by Rick » Fri, 07 Oct 2005 05:37:50

First, does the form "close" or does it become hidden? If it closes, then
the report and/or query won't be able to pull any data.

Sounds like you have your enter key behavior not set to go to the next
field, or your tab order is messed up in some way. Either fix the enter key
behavior, or try pressing tab instead of enter.

--
Rick B