Recordset is locking and won't update

[RBE]

Hi, lots of detail in this one. I have a form in the forms record source I have this sql statement...

SELECT [TENDERS TABLE].[Destination Terminal], [TENDERS TABLE].[Destination City], [TENDERS TABLE].[Gallons Received], [TENDERS TABLE].[Date Received], [TENDERS TABLE].[Pumping Ticket #], [TENDERS TABLE].Batch, tblTERMINCOMGL_1.[Terminaling Income for PFC Tank], tblTERMINCOMGL_1.PAID, tblTHRUPUTGL.[Thru-put Adj Value from PFC transfer], tblTHRUPUTGL.PAID, tblTERMINALINGGL.Terminaling, tblTERMINALINGGL.PAID, tblTARIFFGL.[Pipeline Tariff to be accrued], tblTARIFFGL.PAID
FROM tblTERMINALINGGL RIGHT JOIN (tblTHRUPUTGL RIGHT JOIN (tblTARIFFGL RIGHT JOIN (tblTERMINCOMGL AS tblTERMINCOMGL_1 RIGHT JOIN [TENDERS TABLE] ON tblTERMINCOMGL_1.[Pumping Ticket #] = [TENDERS TABLE].[Pumping Ticket #]) ON tblTARIFFGL.[Pumping Ticket #] = [TENDERS TABLE].[Pumping Ticket #]) ON tblTHRUPUTGL.[Pumping Ticket #] = [TENDERS TABLE].[Pumping Ticket #]) ON tblTERMINALINGGL.[Pumping Ticket #] = [TENDERS TABLE].[Pumping Ticket #]
WHERE ((([TENDERS TABLE].[Gallons Received])>0));

The records that pull up will not allow me to edit. I keep getting a cannot update the recordset error. I made sure all the controls were set to edit but that is not the problem so I figure that it has to be in the sql statement. It is pulling records from 5 different tables and bringing the values into the form so I can "EDIT" them. The tenders table is my main data entry table and the others are GL tables. Any help on this would be appreicated.

 

[JoeMiller]

One of your joins is causing the query to be non-editable. Without knowing the table structure it's not possible to tell you which one, but reduce the complexity of the query by removing one table at a time until you can see the new record line in the query (with the *). Then you'll be all set.

HTH Joe Miller
joe.miller@flotech.net

 

[RBE]

Just for more information on this issue. I did a little research on the issue in the many books I have and found that Join querys although are not editable in the query datasheet view itself are editable in a form if the form's recordset type control is set to Dynaset (Inconsistent Updates)and the data entry control is set to no, all other editing controls should be set to yes. This worked and the form is pulling editable data now. Thanks for all your help. This site is the best board I belong to and it is because of all the helpful people. RBE