Form opening at incorrect field??????

[Rosscoah]

Hello,

This is probably pretty simple but i can't find any info on it on this forum:

Every time i open my form the cursor automatically selects a field halfway down the page. How do i get it to open with the cursor at the first field on the form???

Also, I would like the form to be maximised upon opening anyone know how to do this?

Thanks

 

[Matt Greatorex]

Put 'DoCmd.Maximize' in the form's On Open event. You can also use the 'SetFocus' function here to move focus to whichever control you want.

You can set the overall tab order for the form by opening the form in design view and going to View - Tab Order.

 

[Rosscoah]

Thanks, the Tab Order sorted it.

The maximise part i'm not having as much luck with. This is how i have entered it in the Event Procedure. It doesn't seem to be working so i'm obviously not on the right track here:

Private Sub Form_Open(Cancel As Integer)

DoCmd.Maximize

End Sub

How should it be written??

 

[boblarson]

Exactly as you have it. Did you put it on the form's open event by just typing
DoCmd.Maximize
in the existing
Private Sub Form_Open(Cancel As Integer)

End Sub
spot, or did you actually type the words "Private Sub Form_Open..."

 

[Rosscoah]

Straight in the spot, i didn't type anything else just the "DoCmd.Maximize" part??

 

[boblarson]

That is weird as that is the correct way to do it. You might try importing everything into a blank database to see if it is a db corruption issue.

 

[Rosscoah]

Thanks Bob, I'll look into it.