enter button

[chr1stoper1]

Hi Guys

Im making a simpl database ad I have a form which populates a table with the information on the form when I click add new record button.


If I use the enter button instead of the tab button to navigate around the form it adds whatever info is on the form at tht point.
Is there a way that the enter button can be used to navigate the form and ony use the add button for data entry?

[pbaldy]

Try changing the cycle property of the form.

[chr1stoper1]

Thanks for the reply but that didnt worky

[davegri]

You would have to use an unbound form. The add button event would run an INSERT query.

[pbaldy]

Can you attach the db here?

[Micron]

you are making this more difficult than it needs to be by not adapting. Don't understand why so many people want a behaviour that's been around for eons to work some other way.
A control that has an enter key property has 2 options - default (which I presume defaults to your db options setting for record navigation) and New Line. If you want it to do something else, you will have to trap for the Enter key press. Then it introduces the issue of whether or not you put it on every control that needs it, or set the form keypreview property to yes/true so that you can just do it for the whole form. What happens when you start combining Enter with other keys like Alt or Ctrl is a guess for me. If you trap the enter key press, don't be surprised if it slows the form down because the db will have to evaluate every key to see if it's the enter key.

One could just learn that key navigation is Tab, and assimilate! Ok, no more soapbox

[pbaldy]

I have apps used by "head down" data entry people that use both. They want the enter key to take them to the next control, the tab key jumps them to the next section (they enter a lot of numbers, so the 10-key enter button is probably fastest for them). I trap for the tab key in a function called from several controls. They haven't complained about form speed, and they're not shy about doing so. They just complained today about one extra keystroke because focus was going to the wrong place in a new feature.

[Dave14867]

Micron,

How do you really feel? Just kidding, loved the response.