Unable to check checkbox in form

[MoiraT]

I have a table with data in it to which I have added a checkbox control, with the format set to Yes/No and the display set to Checkbox. This feeds a query which feeds a continuous form, where the user ticks records they want to select. The checkbox works fine in the table and the query but nothing happens when clicked on the form. Is it something wrong in the form or is it because the data was in place before I added the checkbox to the table?
Appreciate any help, thanks.
Moira

 

[dRahme]

Hi, check and see if you have a control source for the checkbox. Right Click on the checkbox - properties - data -control source. If the field is blank, click in the field and add the control source (the name of your Yes/No field)

Hope that helps.

 

[MoiraT]

Sorry - I should have said I have the control source set to the control on the table. Thanks for your quick response.

 

[MoiraT]

I've answered the second part of my question - it isn't because the data predates the checkbox, the checkbox doesn't work in the form for new records or old records.
Any ideas?

 

[dRahme]

Hi, I am a little confused. If the checkbox doesn't work for new records or old records....what records are left?

If you go to design view and then flip back to form view and the checkbox doesn't work for the existing records then I would think it is a control source problem.

Other than that, you may have a relational problem. Are these records coming from one or multiple tables?

 

[jjlogan]

If I understand, the Yes/No field in the table was set up to indicate whether a record should be selected for some purpose. By having the control on a form (based on a query with the Yes/No field in the query), the Yes/No control should properly update the table field with Yes when checked on the form. It did for me on trial basis in Access version 2000. It will take a second query to select the records that are Yes in the Yes/No field and this 2nd query will have a criteria that the Yes/No field is True.
Hope this helps. Jeff

 

[MoiraT]

I am such an idiot - I've just checked my form properties and I have Allow Edits set to no. That will teach me to copy another form to make a new one (except it probably won't). Sorry for the time waste and thanks for your help.