How to configure a split form to be ready for data entry when it opens?

[steve7800]

I have a form which is bound to a table. The form is set to Split Form. When the form opens I want the user to be able to begin typing in the iDescription text field in the detail section of the form (as opposed to the datasheet section of the split form) and then tab to other fields. The iDescription.SetFocus statement in the Form_Load event does indeed allow the user to enter data into the iDescription text field. But the user cannot tab to or select with the mouse any other field in the detail section of the form. The user is stuck on the iDescription text field.



It is necessary to select the record in the datasheet section with the mouse in order to enter data into other fields of that record.

How can I configure the form or what can I do in VBA code to allow the user to immediately begin entering data in the fields in the detail section and tabbing among those fields?

[June7]

Tried Open event and I see what you mean about not able to move.
However, I then tried the Load event and it works for me.

[Missinglinq]

I had the same results...Focus code in the Form_Load event worked fine.

As a general rule...anything pertaining to data has to be in the Form_Load event, rather than in the Form_Open event.

Linq ;0>