DataBinding

[Savvas]

Hi all,

I have a main form with a datagrid and an edit button. When i click the
edit button, see code below:
If Me.dataset.table.Rows.Count > 0 Then
Dim select As Integer
select = Me.datagrid.Item(Me.datagrid.CurrentRowIndex(), 0)
'the zero above is the columnstyle in the datagrid which is the primary
key of my 'table.
Dim frmNewEdit As New frmAddEdit
frmNewEdit .Incoming = select
'Incoming is the property that sets whether we want to add or edit
frmNewEdit .ShowDialog()
'after i click submit it comes back here
Me.dataset.Clear()
Me.adapter.Fill(Me.dataset.table)
Me.datagrid.Refresh()

And the form with all the textboxes with the data opens. The textboxes
are all bind to the dataset (set at the properties window - Data
Bindings).
When I delete the data from a textbox and move to the next textbox, the
value that was previously typed it reappears again.

How do i avoid that? In some cases, I need the textboxes to be empty.
If there was data already there, and i click edit to remove that value,
the value reappears again.
The code in the edit Form when i click submit is the following:

Me.BindingContext(Me.datasetEdit.table).EndCurrent Edit()
Me.adapterEdit.Update(Me.datasetEdit.table)

Is it maybe the load method of the edit Form? The code is the
following:

Me.adapterEdit.SelectCommand.Parameters("fcpk").Va lue = Me.Incoming
' fcpk is the primary key which is found in the columnstyle which has
the value '0
Me.adapterEdit.Fill(Me.datasetEdit.table)

Also, the edit Form has tabs and groupboxes and the textboxes are
within those

Thanks

Savvas