Enter Key Behavior

[Karen]

Hi,
I have created a form to enter date parameters into a query based on the
example in the Access Help. However, when I use the enter key after entering
the data into the first date field, it enters instead of tabs to the ending
date field. I have selected Tools-Options-Keyboard-Next field.

 

[John Vinson]

Hi,
I have created a form to enter date parameters into a query based on the
example in the Access Help. However, when I use the enter key after entering
the data into the first date field, it enters instead of tabs to the ending
date field. I have selected Tools-Options-Keyboard-Next field.

Check the Tab Order properties of these fields. It's convenient to do
this at the form level - open the form in design view, and right
mouseclick the little square at the upper left intersection of the
rulers. Choose "Tab Order" from the dropdown list. Make sure that the
Ending Date textbox is next after the first date field. My guess is
that the "first date field" is actually last in the tab order, so that
when you press Enter, Access thinks you're done with the record, saves
it,and moves on to the next.

John W. Vinson[MVP]