Recordset is not updatable

[cav]

Thanks for all your help in the past. Your new challenge, and I hope it is an easy one, follows. I am trying to create a quality control Form from a select query. There are 3 tables involved...Empinfo, Rate, and Project. The tables are joined like this: Empinfo [Emp#] to Rate [Emp#]. Rate [Project#] to Project[Project#]. The problem: When trying to input info in the form, such as, in the #completed field I get this "The recordset is not updatable." I appreciate any and all help! Thanks.

 

[DougP]

It has to do with the how you set up the relationship between the two tables. <p> DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br>

 

[cav]

Any idea, Doug or anyone, what the relationship would be since I have tried many different combinations to solve this problem.????? thanks. cav<br>

 

[roundman]

roundman(Programmer) Feb/12/00<br>
Check all table properies for locks?<br>
<br>
Roundman<br>

 

[cmmrfrds]

I just went through something similar with Recordset not updatble. I needed to set Dynaset to inconsistent updates, which is necessary with 3 or more tables joined with many-to-one-to-many.

 

[cav]

I checked all the suggestions above and now have it working. Thanks so much for helping me keep my sanity.

 

[DougP]

If you have your forms recordsource connected to just one table, say the main table and create subfoms for the other two tables then you should be able to add data to each.<br>
So each table is connected to just it's recordsource and NO query.<br>
You can with a little finesse make it look like one trasparent form.<br>
OK <br>
Try making a new form and leave your exixsting form alone in case you need to refer to it.<br>
I do this when I run into your situation.<br>
<br>
<br>
<p> DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br>