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.