Subform won't allow edits to fields

[WCStarks]

I have 3 tables and a query related to this issue.
1) Assets
2) Sites
3) Assets_Trans (M-1 junction table between the Assets and Sites tables)
4) A query which produces a sub-set of the junction table, called Assets_Curr_Trans, based on the most current junction record for each Asset.

I have a continuous sub-form which combines key data from the Assets table, along with key data from their related Assets_Curr_Trans records, for a selected Site (Main Form). This sub-form will not allow me to modify data in any of its controls.

The relationships between the tables/Queries are on normal key ID fields. The SQL query for this form is:

SELECT Assets.Category, Assets.Make, Assets.Model, Assets.Type, Assets_Curr_Trans.Trans_Type, Assets_Curr_Trans.Trans_Date, Assets.BarCode, Assets_Curr_Trans.Custodian, Assets.Group, Sites.ID, Assets_Curr_Trans.Site_ID, Assets.ID, Assets_Curr_Trans.Asset_ID, Assets_Curr_Trans.Comment
FROM (Assets_Curr_Trans INNER JOIN Assets ON Assets_Curr_Trans.Asset_ID = Assets.ID) INNER JOIN Sites ON Assets_Curr_Trans.Site_ID = Sites.ID
ORDER BY Assets.Category, Assets.Make, Assets.Model, Assets.Type, Assets_Curr_Trans.Trans_Date DESC;

Why am I not permitted to edit data in the controls in this sub-form? Is this just the nature of the beast? All properties of the form related to modifying data within, are set to"Yes", and all the controls are "Enabled".

[ranman256]

SOME queries, depending on the joins will NOT allow edits.
The subform should be a simple 1-many on the Master Form ID.

[WCStarks]

So, I guess, in this case, it is the nature of the beast. Thanks

[Missinglinq]

Allen Browne has an excellent article on the more common reasons that some Queries are Read-Only:

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

Linq ;0)>

[WCStarks]

Thank you. I was aware of AllenBrowne's ELookup function, as someone in the form gave me a link to it. Allen seems to have produced a lot of tips and tricks.

[Missinglinq]

Allen, although now retired from all things Access, was really the godfather of Access...in fact, many of his articles are actually part of the official MS Access help articles! When something new to me arises, his website is the first place I look for help!

Linq ;0)>