Subform recordset (set in code) is not updateable

[rdemyan via AccessMonster.com]

I tend to code everything. So I'm trying to set the recordset of a subform
in code and then set the .ControlSource property of each field.

The data is displaying correctly, but the subform isn't allowing me to update
any of the fields or delete or add new records.

I've checked the properties of both the subform and Allow* (ie. Deletions,
edits, etc) is set to true. The subform control on the main form is not
locked.

The subform recordset is based on a single table and the key fields are
selected.

So what gives. Why isn't this working!!? Is it because the recordsource for
the subform is set in code?

Thanks for any suggestions, help, etc.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200610/1

[Tom van Stiphout]

On Sat, 21 Oct 2006 23:15:22 GMT, "rdemyan via AccessMonster.com"
<u6836@uwewrote:

Probably not, but it will only take you a few seconds to break with
your tendency, put the queryname in the recordsource, and repeat the
test.

-Tom.

>I tend to code everything. So I'm trying to set the recordset of a subform
in code and then set the .ControlSource property of each field.

The data is displaying correctly, but the subform isn't allowing me to update
any of the fields or delete or add new records.

I've checked the properties of both the subform and Allow* (ie. Deletions,
edits, etc) is set to true. The subform control on the main form is not
locked.

The subform recordset is based on a single table and the key fields are
selected.

So what gives. Why isn't this working!!? Is it because the recordsource for
the subform is set in code?

Thanks for any suggestions, help, etc.