Cursor Placement

[Janet Ciegler]

In some of my input forms, each time I store the record and redisplay
the form, the cursor automatically returns to the first blank field.
But in other similar forms, the cursor does not return, so one has to
click in that field before entering data. How can I get the cursor to
always return? I have the fields ordered correctly, so that's not it.
Using Access 2000 and DAO vba. Thanks! Jan

 

[DebbieG]

Wherever you're wanting this to happen:

Me.TheFieldName.SetFocus


| In some of my input forms, each time I store the record and redisplay
| the form, the cursor automatically returns to the first blank field.
| But in other similar forms, the cursor does not return, so one has to
| click in that field before entering data. How can I get the cursor to
| always return? I have the fields ordered correctly, so that's not it.
| Using Access 2000 and DAO vba. Thanks! Jan
|

 

[Janet Ciegler]

Thank you, Debbie. That works fine!