Hi Noel,

DataForm does indeed work well, and in fact, I use it often.

The flaw in Dataform is that no matter what record you click on in your
database, Dataform will always show you the first record instead, not
the one you clicked on - very irritating.

In other words, if I click within row 356 in my worksheet and then do
DataForm to see that record, it will show me the record in row 1
instead - not the one I want to see in row 356. It's as if the
Microsoft programmers stopped short when writing this program. And as
many complaints about it as there have been over the years, they still
haven't done anything to correct it.

The code I recommended above (from Dave Peterson) corrects this such
that running the code will now cause DataForm to show you whatever
record you've clicked on within the database (subject to the caveats I
mentioned).

Paul