John,
I am still having trouble. So I started with the most basic of views:

SELECT *;
FROM eh!campunit;
ORDER BY Campunit.facilityno, Campunit.unitno

The form has only the View in the DE
The Send SQL updates is on (thanks for the detailed instructions)
I am marking Facilityno and Unitno as keys.
(neither is unique by itself - but I tried a file w/unique - same-o)

When I run the form, only the last record is visible. No Next, no Previous.

I fooled with Optimistic or Pessimistic buffering.
I changed the View's BufferMode Override to 5

I can't spot what is missing.

Please point out the obvious.

Thanks again,
Sylvia