I have a divided form so above a have the details of the record and below ia have in the datasheet view the list of records.

I also hava a subform, so in the datasheet view a can add and change some fields.

Some of these filelds are shown in the detail form, but I have to refresh manually to see the changes.

I've created a text box control in order to refresh the main window after clicking, but I'd like to come back to the same recoprd automatically.

How could I do that?

Thanks in advance

Try this command!

Me.Requery