title: Troubles with an MS-Access Listbox linked to a YES/NO type field
body: <p>I have a form with 2 listboxs (list1 and list2) that displays the values from 2 YES/NO type fields. On the table the field data is represented by checkboxs but in the listbox it displays as True/False <br>
  I also have 2 comboboxes with Yes and No values which are used to populate/edit the field in the table. </p>
  
  <p>I am trying to edit the VBA code of this form in such a way that the 2 listboxes (and values in the field) can not be true at the same time. i.e if a user selects true on combo1 and hits save, the program will check the value in list2 and, if its also true, display an error message and exit the sub. </p>
  
  <p>i have found that the values are actually saved as 0's and -1's in the list box but my problem is that the value of the list box doesnt change even after changing the value on the table. i.e even though the True/False Values changes accordinly when the value on the table field is changed, the 0's and 1's dont change (found this out by msgboxing the values on the listbox) and this makes it impossible to compare values before saving. </p>
  
  <p>An example of the code i am using is below</p>
  
  <pre><code>...   
  
   List2.Requery
  'MsgBox List2
  
   'MsgBox Combo1
  If Combo1 = "True" And List2.Value = "-1" Then
  MsgBox "List1 and List2 cannot be TRUE at the same time. Please adjust or cancel edit"     
  Exit Sub
  Else
  myr.Edit
  myr![Y/Nfield] = Combo1
  myr.Update
  
  
  Set myr = Nothing 'Close the recordeset 
  
  
  End If
  
  ...
  </code></pre>
  
  <p>(the ... means there are codes before and after this bit)</p>