problem with displaying new row

Hello,
My problem must be very simple to solve, but I havennt
found the answer yet, so any help is appreciated.

I have a form with bound controls, mostly textboxes, to an
access database. When I fill the dataset the datatable
which is used in the binding correctly populates the
controls on the form. All navigation buttons work
perfectly. The edit and delete button do their work
without a problem. After a delete the label which displays
current and total records by counting the rows in the
table is decreased by one as it should.

My only problem is after I add a new row. The row is
added, but I can not navigate to it. The counter adds 1
record, so I know the add was successfull, but when I want
to go to the last record it just doesnt do it. It stops at
record 14/15. I use the me.databidings(dt).position =
dt.rows.count - 1 to jump to the last record, which
normally works, bt doesnt after I added a record.

Finally, when I stop the application and restart the
record the new record is added to the database and I can
use it like any other record.

Any ideas why I cant navigate to the new record after I
created it?

Thanks in advance.

Lozzi
Sun Aug 17 08:49:57 CDT 2003


Thanks for the reply, but I solved it allready. After I
updated the datasource and filled the dataset with the
updated source everything worked like it should.

Lozzi.

>-----Original Message-----
>Show us your code for navigation and for adding the
record.
>
>
>
>"lozzi" <lozzi1@hotmail.com> wrote in message
>news:1e2c01c36395$7058f1a0$3501280a@phx.gbl...
>> Hello,
>> My problem must be very simple to solve, but I havennt
>> found the answer yet, so any help is appreciated.
>>
>> I have a form with bound controls, mostly textboxes,
to an
>> access database. When I fill the dataset the datatable
>> which is used in the binding correctly populates the
>> controls on the form. All navigation buttons work
>> perfectly. The edit and delete button do their work
>> without a problem. After a delete the label which
displays
>> current and total records by counting the rows in the
>> table is decreased by one as it should.
>>
>> My only problem is after I add a new row. The row is
>> added, but I can not navigate to it. The counter adds 1
>> record, so I know the add was successfull, but when I
want
>> to go to the last record it just doesnt do it. It
stops at
>> record 14/15. I use the me.databidings(dt).position =
>> dt.rows.count - 1 to jump to the last record, which
>> normally works, bt doesnt after I added a record.
>>
>> Finally, when I stop the application and restart the
>> record the new record is added to the database and I
can
>> use it like any other record.
>>
>> Any ideas why I cant navigate to the new record after I
>> created it?
>>
>> Thanks in advance.
>>
>
>
>.
>