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

recordsource not updatable

P: 5
Hi ;
I use too mix query ( four relationship and main and child tables :) )
so that of couse my query is not updatable I agree this ! :(
but I want to different thing ; when form is open my mix query is run and take me all data but when I want to change some textbox (recordset dont allow me changing table data )I want to change textbox (not table data) after that I change textbox data with specially recordset in focus sub

how can I close this recordset isnot updatable writing
plese Help

Thanks for thinking
Nov 11 '08 #1
Share this Question
Share on Google+
1 Reply


Expert 100+
P: 374
Hi ;
I use too mix query ( four relationship and main and child tables :) )
so that of couse my query is not updatable I agree this ! :(
but I want to different thing ; when form is open my mix query is run and take me all data but when I want to change some textbox (recordset dont allow me changing table data )I want to change textbox (not table data) after that I change textbox data with specially recordset in focus sub

how can I close this recordset isnot updatable writing
plese Help

Thanks for thinking

Hey beceri,

What I would probably do, even though it doesn't sound very elegant, is that you're going to have to have subforms that aren't tied to the main Multi-Query recordset, and just have a simple form that is bound to that one table that you're wanting to change.

I'm assuming since you didn't provide a lot of details, is that you have many tables that are all related to one another on one way or another, and have cascading updating activated to the parent table. Since you've put those kinds of restriction on the tables, it make it down right difficult to make any changes on a form.

You may want to rethink some of the design of your table structure and put some of those business rules, into the form itself.

Hope that helps,

Joe P.
Nov 17 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.