Hi all,

I have a small problem.. I have a databound form with text boxes, checkboxes, combo boxes and buttons that take care of navigation, save, delete... But the "New Record" button gives me trouble.

I want a "New" button that essentially does the same thing as the Binding Navigator. I want to press the button and all the databound fields clear and we're looking at a new record. But I can't find any instructions on doing this.

Here's the code I have so far(which doesn't work right):
    Me.DsMyDatasource.tblMyTable.Rows.Add()

I get error:
    :("Column '...MyMandatoryField...' does not allow nulls."

Obviously its expecting a new record complete with the data. But I want to give the user a chance to enter these details in first, then click on "Save".

Can anyone help me?
Thanks,
Kia

Hmm... seems nobody knows the answer... Lucky I've now found a solutions.

For those who are looking here due to having the same issue, I can point out that the Binding Source is best for most of your record navigation and operations.

Me.bsMyBindingSource.AddNew
    .MoveNext
    .MovePrevious
    ...

.AddNew will move the pointer to a new row.

Kia