Going to next record using vba affects tab order

[burrina]

I have command buttons my form that work fine and tab to the next command button. I tried using vba code on key down and exit for the command buttons but it made my tab order mess up.

Here is my vba code; DoCmd.GoToRecord , , acNext

Is there a better or different way to approach this without affecting my tab order ?

[John_G]

Hi -

Why are you using command buttons to tab to the next button? Won't the TAB key serve the same purpose?

What do you mean by the tab order gets messed up? It shouldn't, since it's a part of the form. You might end up with the focus (cursor) on the wrong control, but that's a different issue. Is there a reason why you are using the Key Down event? Command buttons normally use the On Click event to perform an action.

Can you provide more information on what you are trying to do?

John

[burrina]

I have buttons on my form. I am NOT using them as tab keys, they have their own code that runs. I just need to tab to the next button after firing the code on the button. I typically use the tab key to navigate my db by default. The command buttons do use the on click event. Do I then need to enter this code to fire right after the on click event as well?

This an example of all he command button does.;

CallNexttDte = two.Value ' which sets the date for another field.

[John_G]

Hi -

All you need to do is add DoCmd.GoToControl "ButtonName" as the last line in the On_Click event, to take you to the next command button (or any other control). No need to worry about the tab order.

John