okay i'm really sorry for asking so many questions but it would be really great if some one could tell me or give me an idea as to what i'm doing wrong. from what i can tell from the two books i'm looking through this should work to update my database but it isn't. any suggestions would be great please.

Private Sub CmdCancel_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles CmdCancel.Click
End
End Sub

Private Sub FrmRegister_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
OleDbDataAdapter1.Fill(Datasetup1)
TxtUserName.Text = ""
TxtPassWord.Text = ""
TxtCity.Text = ""

End Sub

Private Sub CmdEnter_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles CmdEnter.Click
If TxtUserName.Text = "" Then
MessageBox.Show("Please Enter a User Name", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error)
Else
If TxtPassWord.Text <> TxtConfirm.Text Then
MessageBox.Show("Please check password(s) entered correctly", "Error", MessageBoxButtons.OK, MessageBoxIcon.Hand)
Else
If TxtCity.Text = "" Then
MessageBox.Show("Please Enter a City", "Error", MessageBoxButtons.OK, MessageBoxIcon.Hand)
Else
End If
Datasetup1.AcceptChanges()
OleDbDataAdapter1.Update(Datasetup1)

End If
End If
End Sub
End Class