I am getting an invalid operation error on the underlined section of code. I cant understand it im copying straight from a book for this stuff and the book always seems to be wrong.
VB Code:
  1. rs.Open strSQL, cnn, adOpenDynamic, adLockOptimistic, adCmdText

  2. StatetoAdd = Me.lstStateList.ListIndex

  3. With rs

  4. [U].AddNew[/U]!FK_State = StatetoAdd

  5. .Update

  6. .Close

  7. Populate_lstEmpStates

  8. End With