Subform based on a query wont allow editing

  • Thread starter Thread starter mscertified
  • Start date Start date
M

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
 
mscertified said:
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
Click to expand...


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;
 
Back
Top