By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,318 Members | 2,107 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,318 IT Pros & Developers. It's quick & easy.

Subform recordset (set in code) is not updateable

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.