Hi..

I have a form which has command buttons and fields in it. When I end the data in field 1 and press Return key on keyboard, it then goes to a command button, but I don't want it to go there. I want it to go to the next field below it. How do I do this?

please help..

Thankyou in advance

Ruby

You can use the control properties "Tab Stop", and "Tab Index" to control how the cursor skips from field to field.

If you set Tab Stop to No, the cursor will not stop on that control.

Tab Index is the tab stop order, so after creating the form, it's usually a good idea to go back and make sure that these index values proceed from control to control in a sensible way.

Hope this helps,

Peter De Baets
Peter's Software
MS Access tools for developers http://www.peterssoftware.com

Thankyou Peter....it has worked..