Set focus?

[Niniel]

Hello,

I am using a command button on my form to start a new record.
I would like that new record to show up in a way that the top part of the form is visible, and not the bottom half.
I thought that if I set the focus to the first combo box on the form, I'd achieve my goal, but either I am not doing this correctly, or the entire idea is flawed.

DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
DoCmd.GoToRecord , , acNewRec
Set Focus = Me.CIKID

Provided that using focus is a workable method, would it be better to set the focus from the On Load or On Open events instead?

 

[Niniel]

Never mind, I figured it out.

On Current
me.[control].setfocus

 

[CEH]

Setting your focus is not going to change the visible property of a field or fields on your form. Someone correct me if I am wrong ... But I believe you would want to set the visible property of your "Bottom half" to False, on the onopen event of the form.

 

[Niniel]

Now that is an interesting idea.
I don't think it would be practical in my case, however.
Setting the focus to a particular control works well enough since it does scroll the form up. Not all the way, but 99 % of it. Not perfect, but acceptable.