Tickbox is grey on a form when using a query as a source

[NickSamuel]

I created a query from three tables and checked its output which was correct.

I then used the wizard to create a form to display the records produced by this query.

I expected the appearance to be the same as forms used to display the records o individual tables (also created using the wizard.)

The source tables included booleans and the tic boxes. The forms for individual tables displayed these as ticks against a blue background or white with no tick (true/false).

The corresponding tickboxes in the form sourced from the query were grey. They went darker grey for ‘true’.

Trial-and-error found that the ticks would be displayed if 3D was switched off - this was not an issue for the forms displaying data from individual tables.

The now-displayed tickboxes now had a tick against a grey background and not blue, as in the other forms, and ‘false’ was still grey not white.

I have tried all-sorts but have not been able to get the form from the query displaying the booleans in the same way as the forms from the tables.

I have hunted the topics and have not found this issue.

[skyandrews]

The checkbox is greyed out because the form source is the query based on three different tables,meaning modifications are not allowed. To enable the checkbox, here are a couple options:
Option1

• create a subform in the MainForm, with its source on “tableB” (the table where the checkbox data is saved)
• “Link” this subform to the Mainform (mainform is based on the query) by linking subform.“tableBkey” to MainForm.“tableBkey” (tableBkey is the column in the query used to relate tableB to other tables)
  Option 2
• create a join table based on the query. This table should have multiple primary keys related to each of the tables in the query.
• give the table a relevant name to the types of data joined, “joinItemDetails”)
• in the relationship tool, join the new join table (“joinItemDetails”) primary keys to the appropriate pimary keys of the related tables.
• replace the query with the new “joinItemDetails” table as the table source of the form where the checkbox resides.

[NickSamuel]

Great answer, thank you. I do not intend to use the form for updating so I will not have to do anything at the moment. The option of the subforms might be a good one in future.

The answer does not explain the absence of ‘ticks’ when 3D is chosen. Also, the text boxes are not coloured to indicate that they cannot be updated are they?