When my form is loaded the cursor appears in a text box about half way down the form. Is there a way to set the cursor location in the first text box on the form? Thanks for any help.

In the Form's Current event, use Me.ControlYouWantToStartIn.SetFocus (this is VBA code, obviously, but it's painless).

You're probably jumping to a new record in the same field you were in the old one in. One thing this code will affect is when you search for a field, you will no longer stay in that field after the search is run. This can be mildly confusing/annoying if your users are not ready for it.

HTH,
David R

Have you tried View/Tab Order and rearranging the custome order? You can do that in design view of the form

Thank you both for your help. I was able to do the setfocus in the form load event to set the cursor to the textbox I wanted. Thanks again.

D B Lawson is correct though about something I didn't consider. If you've done a lot of shifting around and adding new fields on your form, the tab order might be very skewed. Under Design View>View>Tab Order, try Auto and then fine-tune it the way you want it.
You can skip the Auto sort if it's still mostly fine.

David R

[This message has been edited by David R (edited 01-29-2002).]

David - I checked the tab order and it was set up correctly. For some reason it still kept jumping to a text box about half way down. I used the setfocus and it seems to be working. Thanks for your help I'm still new at using access.