Help on Query as RecordSource

[Excel_Kid1081]

Hello-

I have the following SQL statement as my RecordSource however on the form itself a user cannot edit any records. I have the relationships set up properly (1:M on ObligorID), checked to make sure the data types were matching on the Primary and Foreign Keys, RecordsetType is set to Dynaset, no Record Locks, Additions, Deletions & Data Entry are all set to “Yes” so I am confused on why this won’t work:

SELECT tblObligors.Obligor, tblObligors.Current_Analyst, tblObligors.IsNonRated, tblObligors.Approval_Date, tblObligors.Fiscal_Year_End, tblReviews.Review_Date, tblReviews.Internal_Rating, tblReviews.Notes, tblReviews.Trading_Bucket, tblModelsAndDocs.Excel_Model, tblModelsAndDocs.Official_Statement FROM (tblObligors INNER JOIN tblModelsAndDocs ON tblObligors.Obligor_ID=tblModelsAndDocs.Obligor_ID) INNER JOIN tblReviews ON tblObligors.Obligor_ID=tblReviews.Obligor_ID;

Any thoughts or ideas are much appreciated. Thank you! EK

 

[ajetrumpet]

have you taken a look at Allen browne's nonupdatable query list? i'm guessing the query is non-updatable.

 

[missinglinq]

Here's a link to the article Adam is talking about:

http://allenbrowne.com/ser-61.html

 

[Excel_Kid1081]

yes, i took a look at that and nothing I have looks like it falls on the list so thats where the confusion comes in.....

 

[ajetrumpet]

next step would probably be to run your fingers through the hairs of the property sheet. AND any other code associated with the form's events.

 

[boblarson]

Any thoughts or ideas are much appreciated. [/SIZE][/FONT]

Can you run this in the query window and is it updateable there?

 

[Excel_Kid1081]

OK..been going through the property sheets but not seeing anything so far....I have tried the SQL in just a query and it is not letting me edit there either so looks like it must be something with the Joins then??

 

[boblarson]

...so looks like it must be something with the Joins then??

Probably the case.

 

[WIS]

Hello-

I have the following SQL statement as my RecordSource however on the form itself a user cannot edit any records. I have the relationships set up properly (1:M on ObligorID), checked to make sure the data types were matching on the Primary and Foreign Keys, RecordsetType is set to Dynaset, no Record Locks, Additions, Deletions & Data Entry are all set to “Yes” so I am confused on why this won’t work:

SELECT tblObligors.Obligor, tblObligors.Current_Analyst, tblObligors.IsNonRated, tblObligors.Approval_Date, tblObligors.Fiscal_Year_End, tblReviews.Review_Date, tblReviews.Internal_Rating, tblReviews.Notes, tblReviews.Trading_Bucket, tblModelsAndDocs.Excel_Model, tblModelsAndDocs.Official_Statement FROM (tblObligors INNER JOIN tblModelsAndDocs ON tblObligors.Obligor_ID=tblModelsAndDocs.Obligor_ID) INNER JOIN tblReviews ON tblObligors.Obligor_ID=tblReviews.Obligor_ID;

Any thoughts or ideas are much appreciated. Thank you! EK

Run the query on its own and go to the bottom of the records it is producing. If the * on the Navigation Buttons is grayed out that means that the recordset (query) is not updatable and so you won't be able to edit/add/delete any records from the form. You then have to make the Recordsource of the form updatable.