469,946 Members | 1,739 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,946 developers. It's quick & easy.

Subform recordset (set in code) is not updateable

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

Oct 21 '06 #1
1 1777
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.
Oct 22 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

11 posts views Thread by Ian Ornstein | last post: by
3 posts views Thread by Simone | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.