Hi Paul

Sure. But given that the OP had apparently only recently graduated from
Works and hadn't yet even explored all the menu options or studied the
available help, a code offering may appear a bit overwhelming. "Just
copy and paste the following code into a module in the VBE" may make
sense to you and me, but not necessarily to a novice.

Notwithstanding, I'm grateful (to both you and the author) for the code
which I'll certainly be using in some of my projects.

Noel

Paul D. Simon wrote:

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