Unbound Continuous Forms

From another forum, I found a way to kind of sort of use an unbound continuous form.

Create the form with no recordsource.
But create the textboxes with a recordsource of the field name where the data is going to come from.

in Form_Load you open a recordset, then set me.form.recordset = rs.

The form is not actually bound to the table or query, but to a copy of the records in the recordset. It is read-only.

To get around it being read-only I want the user to click on the field they want to change. This opens up a editable text box where they can change the text. I then do an update sql to update the source table.

But the recordset still shows the old value. So I have tried to do a me.form.requery. The first time it appears to work. The form has the updated value, but more often than not, all the records after the first seem to be dead, the click event does nothing.

If I had edited the first record, more often than not, all the fields in all the records will say "#Name?"

Any ideas what is happening?

Thanks,
David