Solved Restricting recordsets to improve performance (2 Viewers)

[MajP]

Another solution to your 1 record problem is to use an unbound zoom form.
Show the value the user can edit and build an update sql statement to save the changed value.

My first proposed solution was the unbound zoom. Did it a little different, but similar idea.