Check Box Option in joined query

  • Thread starter Thread starter MattB
  • Start date Start date
M

MattB

Does anyone know how to get check boxes to work in a query where there are
two tables joined? For some reason the check boxes don’t work when there is a
join to another table, it's like it's read only. But if you pull the table
(with the check boxes) by itself the check boxes work… Any ideas?
 
You probably have an un-updatable query. Post the SQL by opening in design
view, click on VIEW - SQL View, highlight all, copy, and paste in a post so a
suggestion might be provided.
 
Here ya go. Thanks!

SELECT [ALL CIRCUITS DATABASE].[Vendor Name], tbl_actuals_month.[September
2009], tbl_actuals_month.[October 2009], tbl_actuals_month.[November 2009],
tbl_actuals_month.[December 2009]
FROM [ALL CIRCUITS DATABASE] INNER JOIN tbl_actuals_month ON [ALL CIRCUITS
DATABASE].ID = tbl_actuals_month.ID;
 
GRRR, the table that is being updated didn't have a primary key... That's why
it wasn't working... Thanks for sending me in the right direction Karl!!!

MattB said:
Here ya go. Thanks!

SELECT [ALL CIRCUITS DATABASE].[Vendor Name], tbl_actuals_month.[September
2009], tbl_actuals_month.[October 2009], tbl_actuals_month.[November 2009],
tbl_actuals_month.[December 2009]
FROM [ALL CIRCUITS DATABASE] INNER JOIN tbl_actuals_month ON [ALL CIRCUITS
DATABASE].ID = tbl_actuals_month.ID;


KARL DEWEY said:
You probably have an un-updatable query. Post the SQL by opening in design
view, click on VIEW - SQL View, highlight all, copy, and paste in a post so a
suggestion might be provided.
Click to expand...
Click to expand...
 
Back
Top