I have a form with a sub form which displays a few fields.  The user can
click a details button which opens another form for viewing all of the
fields.  What I'd like to be able to do is when the user closes the second
form, refresh the "parent" form, then redirect the sub form back to the
record it was on prior to the refresh.

Is there a graceful way to do this?

Thanks much,

Ken

The general idea is to save the record's id field in a
variable, requery the form, then use the form's
RecordsetClone to do a FindFirst for the id save in the
variable and finally, set the form's Bookmark to the
RecordsetClone's Bookmark.  The details depend on your table
design, what kind of recordsets you're using, etc.

Marsh