I have a table (Contacts) that has a Yes/No data type field named Active. I also have a form which has an option group containing 2 check boxes.
What I am trying to do is make it so that the user can select either the Active checkbox or the Not Active checkbox in the form which should then update the field (Active) in the table (i.e. if the user selects Active (in the form) the Active field in the table should show this and if the user selects Not Active (in the form) the Active field in the table should show this). However I only seem to be able to get the checkboxes to give the option value 1 or 2 and the table will only accept True or False or Yes or No therefore meaning that the table is not being updated (I realised this instantly when I clicked a check box and no tick appeared in it - this was proven when I opened the table. Do I need to use VBA code and if so how would I go about doing this? I'm sorry if this sounds vague
Help would be greatly appreciated. Thanks!