Check Box Option in joined query

[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?

 

[KARL DEWEY]

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.

 

[MattB]

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;

 

[MattB]

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!!!

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;

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.