Subform based on a query wont allow editing

[mscertified]

I have a subform based on a query that will not allow me to edit the data.
Does this mean the query is not updatable? Is there a way to confirm this? My
query is:

SELECT TD.*, DT.*
FROM tblTicketData AS TD, tblTicketDataType AS DT
WHERE TD.DTID = DT.ID;

and I am trying to update a column in tblTicketData

 

[Dirk Goldgar]

I have a subform based on a query that will not allow me to edit the data.
Does this mean the query is not updatable? Is there a way to confirm this?
My
query is:

SELECT TD.*, DT.*
FROM tblTicketData AS TD, tblTicketDataType AS DT
WHERE TD.DTID = DT.ID;

and I am trying to update a column in tblTicketData

If you open the query directly in datasheet view and can't edit it, then
it's not updatable. In this case, I suspect your problem will be solved if
you reframe your query so that it explicitly joins the two tables:

SELECT TD.*, DT.*
FROM tblTicketData AS TD INNER JOIN tblTicketDataType AS DT
ON TD.DTID = DT.ID;